Returns all statuses associated with active Jira workflows. This view provides a read-only list of workflow statuses along with their categories. To create, update, or delete statuses, use the Statuses table (Cloud only).

View-specific Information

SELECT

The driver uses the Jira API to process filters based on the Id and Name columns. The driver processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM ActiveStatuses WHERE Id = 1;
SELECT * FROM ActiveStatuses 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	WorkflowStatusCategories.Id		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.