SprintIssues
Query the agile Sprint Issues in Jira.
Table Specific Information
Select
The Jira APIs support the IN operator in filters on SprintId; the driver 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 | The Id of the issue. | |
| Key | String |
Issues.Key | = | Common | The key of the issue. |
| SprintId [KEY] | Integer |
Sprints.Id | =,IN | Common | The sprint the issue is assigned to. |
| IssueTypeId | String |
IssueTypes.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue type Id. |
| IssueTypeName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue type name. | |
| StatusId | Integer |
Statuses.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue status Id. |
| StatusName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue status name. | |
| ProjectId | Integer |
Projects.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The project Id of the issue. |
| ProjectKey | String |
Projects.Key | =,!=,IS,IS NOT,IN,NOT IN | Common | The project key of the issue. |
| ProjectName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The project name of the issue. | |
| ClosedSprintsAggregate | String | Common | The issue's previous sprints that have been closed. | ||
| Created | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The creation date of the issue. | |
| Updated | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The updated date of the issue. |