Returns the projects using a given workflow schema.

View-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the WorkflowSchemeId column. The add-in processes all other filters client-side.

If WorkflowSchemeId is not specified, the add-in automatically queries the WorkflowSchemes table to retrieve the WorkflowSchemeId values. This may result in increased query times.

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

SELECT * FROM WorkflowSchemeProjects WHERE WorkflowSchemeId = 10418;

Columns

Name	Type	References	SupportedOperators	Description
ProjectId	Int	Projects.Id		The unique identifier of the project using this workflow schema.
WorkflowSchemeId	Int	WorkflowSchemes.Id	=	The unique identifier of the workflow schema.