SSIS Components for Jira

Build 26.0.9770

StatusProjectsIssueTypes

Returns the issue types in a project using a given status.

View-Specific Information

SELECT

The component uses the Jira API to process filters based on the ProjectId and StatusId columns. The component 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

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770