ADO.NET Provider for Jira

Build 25.0.9434

Statuses

Lists all available issue statuses in Jira, including custom and default statuses used in workflows.

Select

The provider will use the Jira APIs to process filters that refer to the Id or Name columns. Searches on the Name column are case sensitive.

The provider will process the rest of the filter client side within itself. For example, the following queries are processed server-side:

SELECT * FROM Statuses WHERE Id = '10003'

SELECT * FROM Statuses WHERE Name = 'Closed'

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] Integer = Common The unique identifier for the issue status. Used internally to reference the status in workflows and issue transitions.
Name String = Common The display name of the status, such as 'To Do', 'In Progress', or 'Done'. Shown in issue views and workflows.
Description String Common A description of the status that provides more detail about its intended use or purpose in the workflow.
CategoryId Integer Common The ID of the status category that this status belongs to. Categories group similar statuses, such as all 'done' states.
CategoryKey String Common The key value representing the category of the status. Common values include 'new', 'indeterminate', or 'done'.

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