ODBC Driver for Jira

Build 24.0.8963

Sprints

Query,create, modify and delete the agile Sprints in Jira.

Table Specific Information

Select

To retrieve a list of Sprints in your Jira account, you can query the BoardSprints view.

The driver uses the Jira API to process some of the filters. The driver will process the rest of the filter client side within itself. For example, the following query is processed server-side:

SELECT * FROM Sprints WHERE Id = 122 
SELECT * FROM Sprints WHERE Id IN ('1', '2', '3')

INSERT

Create a new sprint and link it to a board. The OriginBoardId and the Name columns are required for inserting a new sprint.

INSERT INTO Sprints (OriginBoardId, Name, Goal, StartDate, EndDate) VALUES ('1', 'Inserted Sprint', 'Complete target', '2018-02-02', '2018-04-04')

Update

Make changes to a sprint by specifying the sprint's Id.

UPDATE Sprints SET State = 'active' WHERE Id = 305

Delete

Remove a sprint by specifying the Id.

DELETE FROM Sprints WHERE Id = 305

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Integer True =,IN Common

The Id of the sprint.

Name String False Common

The name of the sprint.

State String False = Common

The state of the sprint. A newly created sprint starts in the 'future' state. The state can only transition from 'future' to 'active', and from 'active' to 'closed'

The allowed values are future, active, closed.

Goal String False Common

The goal assigned for the sprint.

OriginBoardId Integer False

Boards.Id

Common

The board Id the sprint originated from. This field cannot be updated

StartDate Datetime False Common

The date when the sprint was started.

EndDate Datetime False Common

The date when the sprint has ended.

CompleteDate Datetime True Common

The date when the sprint was completed.

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