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')

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

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.