SprintIssues
Retrieves issues assigned to agile sprints, including their rank and progress within the sprint.
Table Specific Information
Select
The Jira APIs support the IN operator in filters on SprintId; the connector executes the rest of the filter client side within itself. For example, following query's filter is processed server side:
SELECT * FROM SprintIssues WHERE SprintId = '1'
Using the IN operator:
SELECT * FROM SprintIssues WHERE SprintId IN (70, 215)
Note that 'kanban' type boards do not support sprints. You can retrieve all sprint issues faster if you use a filter like the following:
SELECT * FROM SprintIssues WHERE SprintId IN (SELECT Id FROM BoardSprints WHERE BoardId IN (SELECT Id FROM Boards WHERE Type != 'kanban'))
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | Integer |
Issues.Id | Common | A unique numeric identifier assigned to the issue. This ID is used internally by Jira to distinguish each issue. | |
| Key | String |
Issues.Key | = | Common | The unique issue key assigned by Jira, typically consisting of the project key and issue number (for example, 'PROJ-101'). |
| SprintId [KEY] | Integer |
Sprints.Id | =,IN | Common | The unique identifier of the sprint that the issue is currently assigned to. Sprints are used to group issues during Agile development cycles. |
| IssueTypeId | String |
IssueTypes.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The internal ID that represents the type of the issue, such as 'Bug', 'Task', 'Story', or 'Epic'. Useful for referencing issue types programmatically. |
| IssueTypeName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The display name of the issue type (for example, 'Bug' or 'Story'), providing human-readable context for the issue's purpose. | |
| StatusId | Integer |
Statuses.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The internal identifier of the issue's current status within the workflow (for example, 'To Do', 'In Progress', or 'Done'). |
| StatusName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The name of the issue's current workflow status. Helps indicate where the issue stands in the development lifecycle. | |
| ProjectId | Integer |
Projects.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The unique numeric identifier of the project that the issue belongs to. This links the issue to its parent project in Jira. |
| ProjectKey | String |
Projects.Key | =,!=,IS,IS NOT,IN,NOT IN | Common | The short key used to identify the project (for example, 'PROJ'). This is part of the issue key and is unique across Jira. |
| ProjectName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The full name of the project associated with the issue. Helps provide context for teams and stakeholders. | |
| ClosedSprintsAggregate | String | Common | A comma-separated list of previously closed sprints in which this issue appeared. Useful for historical tracking of issue progress. | ||
| Created | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time when the issue was originally created in Jira. Helps in tracking issue age and backlog metrics. | |
| Updated | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time when the issue was most recently modified, including status updates, comments, or field changes. |