ODBC Driver for Jira

Build 24.0.8963

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963