WorkflowStatuses
Displays all statuses used in Jira workflows, along with their properties and associated categories.
Table Specific Information
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
For example, the following queries are processed server side:
SELECT * FROM WorkflowStatuses WHERE Id = 1 SELECT * FROM WorkflowStatuses WHERE Name = 'Open'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | String | = | Common | The unique identifier of the workflow status. Each status represents a step in a Jira issue's lifecycle, such as 'To Do', 'In Progress', or 'Done'. | |
| StatusCategoryId | Integer | Common | The ID of the status category that this workflow status belongs to. Status categories provide high-level groupings for Jira statuses, such as 'In Progress'. | ||
| Name | String | = | Common | The user-visible name of the workflow status. This name appears in the Jira interface when viewing or editing issues. | |
| Description | String | Common | A brief explanation of what this status represents within a workflow. This helps users understand when to use the status. | ||
| URL | String | Common | The REST API endpoint URL for retrieving or managing this workflow status. | ||
| IconUrl | String | Common | The full URL to the icon image associated with this status, used in the Jira UI for visual reference. |