Projects
Provides access to all Jira projects. Supports querying, creating, updating, and deleting project records.
Table-Specific Information
SELECT
The driver uses the Jira API to process filters based on the Id, Key, Name, ProjectTypeKey, and ProjectCategoryId columns when connected to Jira Cloud. The driver processes all other filters client-side.For example, the following queries are processed server-side:
SELECT * FROM Projects WHERE Id = 10000;
The Jira Cloud API also supports ORDER BY for the Key, Name, LeadDisplayName, and ProjectCategoryName columns.
SELECT * FROM Projects ORDER BY Name ASC;
INSERT
Insert a project by specifying the following fields:- Key
- Name
- LeadName
- ProjectTypeKey
INSERT INTO Projects (Key, Name, LeadName, ProjectTypeKey, Description) VALUES ('EXE4', 'Inserted Project 4', 'admin', 'business', 'New business project.');
UPDATE
Update a project by specifying the Id or Key column and the columns to update.UPDATE Projects SET Description = 'Updated description', AssigneeType = 'UNASSIGNED', LeadName = 'admin2' WHERE Key = 'EXE4';
DELETE
Delete a project by specifying the Id or Key column.DELETE FROM Projects WHERE Key = 'EXE4';
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | Int | True | = | Common |
A unique numeric identifier assigned to the project within the Jira instance. This ID is used internally and in API requests to reference the project. | |
| Key | String | False | = | Common |
The short, unique project key used as a prefix for issue identifiers (such as 'PROJ-123'). It is typically assigned when the project is created and used in search queries and issue references. | |
| Name | String | False | Common |
The full display name of the project as seen in the Jira UI. This is the main title used to identify the project in dashboards, boards, and menus. | ||
| Description | String | False | Common |
A free-text description that provides an overview of the project's purpose, goals, stakeholders, or context. Often used to help team members and collaborators understand the scope of the project. | ||
| LeadEmailAddress | String | True | Users.EmailAddress | Common |
The email address of the user assigned as the project lead. The project lead is typically responsible for managing the project and receives notifications by default. | |
| LeadDisplayName | String | True | Users.DisplayName | Common |
The display name (as shown in the Jira UI) of the user designated as the lead for the project. | |
| ComponentsAggregate | String | True | Common |
A comma-separated list of all components configured in the project. Components are used to categorize issues within a project and can represent subsystems, teams, or functional areas. | ||
| IssueTypesAggregate | String | True | Common |
A comma-separated list of the issue types available in the project, such as 'Bug', 'Task', 'Story', 'Epic', or custom issue types. Each issue type defines a distinct kind of work item. | ||
| Url | String | True | Common |
A user-defined web URL that can be associated with the project for external references, documentation, or integration. This field is optional. | ||
| String | True | Common |
The email address associated with the project, typically used for contact or notification purposes. This value can be customized per project. | |||
| AssigneeType | String | False | Common |
Indicates the default assignment strategy for new issues created in the project. Common values include 'UNASSIGNED' or 'PROJECT_LEAD'. | ||
| VersionsAggregate | String | True | Common |
A comma-separated list of version names configured in the project. Versions can be used for release planning and tracking progress toward a release milestone. | ||
| RolesAggregate | String | True | Common |
A comma-separated list of roles defined in the project, such as 'Administrator', 'Developer', or 'Viewer'. Each role controls the permissions and responsibilities of users in the project. | ||
| ProjectKeysAggregate | String | True | Common |
A list of all project keys historically associated with this project. This includes previous keys if the project key has ever been changed. | ||
| ProjectCategoryId | String | False | Common |
The identifier of the project category to which this project belongs. Categories group projects into logical sets for filtering and reporting. | ||
| ProjectCategoryName | String | True | Common |
The name of the category assigned to this project. This is used to organize and display projects by type or purpose in the Jira interface. | ||
| ProjectCategoryDescription | String | True | Common |
A free-text description of the project category, used to provide additional context or clarification for users browsing categorized projects. | ||
| ProjectTypeKey | String | False | Common |
The key representing the type of project. Common values include 'software', 'service_desk', or 'business', which determine the features and interface available. | ||
| LeadAccountId | String | False | Users.AccountId | Cloud |
The unique Atlassian account ID of the project lead. This identifier is consistent across all Atlassian Cloud products and replaces deprecated user keys. | |
| LeadAccountKey | String | True | Users.Key | Server |
[DEPRECATED] A legacy identifier used to represent the project lead, typically replaced by LeadAccountId in modern Jira Cloud instances. | |
| LeadAccountName | String | False | Users.Name | Server |
[DEPRECATED] The legacy username of the project lead, used in older Jira Server installations. Replaced by account ID in Jira Cloud. | |
| Simplified | Boolean | True | Cloud |
Indicates whether the project is team-managed (formerly called next-gen) or company-managed. Team-managed projects allow simplified configuration by project admins. | ||
| ItemURL | String | True | Common |
A direct URL to the project in the Jira web interface, allowing users to quickly navigate to the project's main overview page. |