StatusProjects
Returns the projects using a given status.
Note: This view is available only in the Jira Cloud version.
Table Specific Information
Select
The server uses the Jira API to process to process filters based on the StatusId. If StatusId is not specified the driver uses the Statuses table to automatically retrive the StatusId.
The server processes other filters within the server.
For example, the following queries are processed server side:
select * from StatusProjects where StatusId= 6
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| ProjectId | Int |
Projects.Id | Cloud | The unique idetifier of the workflow for the given status. | |
| StatusId | Int |
Statuses.Id | = | Cloud | The unique idetifier of the status. |