Projects
Query, update, insert and delete the available Projects in Jira.
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Projects WHERE Id = 10000
INSERT
挿入には、Key、Name、LeadName、およびProjectTypeKey が必要です。次のクエリは、新しいプロジェクトを作成します。
INSERT INTO Projects (Key, Name, LeadName, ProjectTypeKey, Description) VALUES ('EXE4', 'Inserted Project 4', 'admin', 'business', 'New business project.')
Update
Id かKey のいずれかを指定して更新できます。
UPDATE Projects SET Description = 'Updated description', AssigneeType = 'UNASSIGNED', LeadName = 'admin2' WHERE Key = 'EXE4'
Delete
Id かKey のいずれかを指定してプロジェクトを削除できます。
DELETE FROM Projects WHERE Key = 'EXE4'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | Int | True | = | Common |
The Id of the project. | |
| Key | String | False | = | Common |
The key of the project. | |
| Name | String | False | Common |
The name of the project. | ||
| Description | String | False | Common |
The description of the project. | ||
| LeadEmailAddress | String | True |
Users.EmailAddress | Common |
The email address of the project lead. | |
| LeadDisplayName | String | True |
Users.DisplayName | Common |
The display name of the project lead. | |
| ComponentsAggregate | String | True | Common |
The components of the project. | ||
| IssueTypesAggregate | String | True | Common |
The issue types of the project. | ||
| Url | String | True | Common |
The URL of the project. | ||
| String | True | Common |
The email of the project. | |||
| AssigneeType | String | False | Common |
The assignee type of the project. | ||
| VersionsAggregate | String | True | Common |
The versions of the project. | ||
| RolesAggregate | String | True | Common |
The roles of the project. | ||
| ProjectKeysAggregate | String | True | Common |
The project keys of the project. | ||
| ProjectCategoryId | String | False | Common |
The Id of the project category. | ||
| ProjectCategoryName | String | True | Common |
The name of the project category. | ||
| ProjectCategoryDescription | String | True | Common |
The description of the project category. | ||
| ProjectTypeKey | String | False | Common |
The key of the project type. Not applicable for update. | ||
| LeadAccountId | String | False |
Users.AccountId | Cloud |
The Id of the project lead. | |
| LeadAccountKey | String | True |
Users.Key | Server |
The Key of the project lead. | |
| LeadAccountName | String | False |
Users.Name | Server |
The user name of the project lead. | |
| Simplified | Boolean | True | Cloud |
Whether the project is team-managed or not. |