Projects
Query, update, insert and delete the available Projects in Jira.
Select
The connector uses the Jira API to process some of the filters.
The connector processes other filters within the connector.
For example, the following queries are processed server side:
SELECT * FROM Projects WHERE Id = 10000
INSERT
Key, Name, LeadName and ProjectTypeKey are required to insert. The following query creates a new project:
INSERT INTO Projects (Key, Name, LeadName, ProjectTypeKey, Description) VALUES ('EXE4', 'Inserted Project 4', 'admin', 'business', 'New business project.')
Update
You can update by specifying either Id or Key:
UPDATE Projects SET Description = 'Updated description', AssigneeType = 'UNASSIGNED', LeadName = 'admin2' WHERE Key = 'EXE4'
Delete
Delete a project by specifying either Id or 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. |