Returns the projects using a given status.

View-Specific Information

SELECT

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

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

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

SELECT * FROM StatusProjects WHERE StatusId = 6;

Columns

Name	Type	References	SupportedOperators	Description
ProjectId	Int	Projects.Id		The unique identifier of the workflow for the given status.
StatusId	Int	Statuses.Id	=	The unique identifier of the status.