SSIS Components for Jira

Build 25.0.9434

WorkflowStatuses

Displays all statuses used in Jira workflows, along with their properties and associated categories.

Table Specific Information

Select

The component uses the Jira API to process some of the filters.

The component processes other filters within the component.

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

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434