JDBC Driver for Jira

Build 22.0.8462

WorkflowStatuses

Query the list of all statuses associated with workflows.

Table Specific Information

Select

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

The driver processes other filters within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

For example, the following queries are processed server side:

SELECT * FROM WorkflowStatuses
SELECT * FROM WorkflowStatuses WHERE Id=1
SELECT * FROM WorkflowStatuses WHERE Name='Open'

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] String = Common The ID of the status.
StatusCategoryId Long

WorkflowStatusCategories.Id

Common The ID of the status category.
Name String = Common The name of the status.
Description String Common The description of the status.
URL String Common The description of the status.
IconUrl String Common The URL of the icon used to represent the status.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462