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 add-in uses the Jira API to process filters based on the Id and Name columns. Searches on the Name column are case sensitive. The add-in 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. |