WorkflowProjects
Returns the projects using a given workflow.
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 WorkflowId. If WorkflowId is not specified the driver uses the Workflows table to automatically retrive the WorkflowId.
The server processes other filters within the server.
For example, the following queries are processed server side:
SELECT * FROM WorkflowProjects WHERE WorkflowId= 'jira'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| ProjectId | Int |
Projects.Id | Cloud | The unique identifier of the project using this workflow. | |
| WorkflowId | String |
Workflows.Id | = | Cloud | The unique identifier of the workflow. |