Projects
Query, update, insert and delete the available Projects in Jira.
Select
本製品 はJira API を使用して一部のフィルタを処理します。
本製品 は他のフィルタを本製品 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
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. |