JDBC Driver for Jira

Build 22.0.8462

WorkflowStatusCategories

Query the list of all status categories.

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 WorkflowStatusCategories
SELECT * FROM WorkflowStatusCategories WHERE Id=1
SELECT * FROM WorkflowStatusCategories WHERE Key='undefined'

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] Long = Common The ID of the status category.
Key String = Common The key of the status category.
Name String Common The name of the status category.
ColorName String Common The name of the color used to represent the status category.
URL String Common The URL of the status category.

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