Statuses
Creates, updates, deletes, and queries Statuses in Jira. On Cloud, uses the Status API which supports full CRUD. SELECT without filters returns only GLOBAL-scoped statuses; PROJECT-scoped statuses must be queried by Id or Name. Requires Administer Projects and Administer Jira permissions on Cloud. On Server, queries the read-only legacy endpoint; INSERT, UPDATE, and DELETE are not supported.
View-Specific Information
SELECT
The driver uses the Jira API to process filters based on the Id and Name columns. Searches on the Name column are case sensitive. The driver processes all other filters client-side.For example, the following queries are processed server-side:
SELECT * FROM Statuses WHERE Id = '10003';
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | String | False | =,IN | Cloud |
The unique integer identifier for the status. Required for UPDATE and DELETE; automatically assigned by Jira on INSERT. | |
| Id [KEY] | Integer | False | =,IN | Server |
The unique integer identifier for the status. | |
| Name | String | False | =,IN | Common |
The display name of the status, such as 'To Do', 'In Progress', or 'Done'. Shown in issue views and workflows. Required for INSERT. Supports filtering with = and IN operators. | |
| Description | String | False | Common |
A description of the status that provides more detail about its intended use or purpose in the workflow. | ||
| CategoryId | Integer | False | Server |
The ID of the status category that this status belongs to. Categories group similar statuses, such as all done states. | ||
| CategoryKey | String | False | Cloud |
The status category key. Use TODO, IN_PROGRESS, or DONE when inserting or updating. Required for INSERT. | ||
| CategoryKey | String | False | Server |
The status category key. Common values are 'new', 'indeterminate', or 'done'. | ||
| Scope | String | False | Cloud |
The scope of the status. Possible values are GLOBAL for instance-wide statuses or PROJECT for project-specific statuses. Required for INSERT. Read-only after creation. | ||
| ScopeProjectId | String | False | Cloud |
The Id of the project that the status is scoped to. Only applicable when Scope is PROJECT. Read-only after creation. |