StatusProjectsIssueTypes
Returns the issue types in a project using a given status.
View-Specific Information
SELECT
The connector uses the Jira API to process filters based on the ProjectId and StatusId columns. The connector processes all other filters client-side.You must specify the ProjectId and StatusId to retrieve results.
For example, the following queries are processed server-side:
SELECT * FROM StatusProjectsIssueTypes WHERE ProjectId = 10100 AND StatusId = 6;
Columns
| Name | Type | References | SupportedOperators | Description |
| IssueTypeId | String | IssueTypes.Id | The unique identifier of the issue type for the project in the given status | |
| ProjectId | Int | Projects.Id | = | The unique identifier of the project using this status |
| StatusId | Int | Statuses.Id | = | The unique identifier of the status |