Returns the projects using a given workflow.

View-Specific Information

SELECT

The connector uses the Jira API to process filters based on the WorkflowId column. The connector processes all other filters client-side.

If WorkflowId is not specified, the connector automatically queries the Workflows table to retrieve the WorkflowId values. This may result in increased query times.

For example, the following queries are processed server-side:

SELECT * FROM WorkflowProjects WHERE WorkflowId = 'jira';

Columns

Name	Type	References	SupportedOperators	Description
ProjectId	Int	Projects.Id		The unique identifier of the project using this workflow.
WorkflowId	String	Workflows.Id	=	The unique identifier of the workflow.