Sprints

Manages Jira sprints. Supports creating, modifying, deleting, and querying sprint data from agile boards.

Table-Specific Information

SELECT

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

The connector uses the Jira API to process filters based on the Id column. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

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

INSERT

Insert a sprint by specifying the OriginBoardId and Name columns.

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

UPDATE

Update a sprint by specifying the Id and the columns to update.

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

DELETE

Delete 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	A unique numeric identifier assigned to the sprint. Used internally to reference the sprint in Jira and API calls.
Name	String	False			Common	The name given to the sprint, typically reflecting its time frame or theme. Helps teams identify and organize sprints easily.
State	String	False		=	Common	The current state of the sprint. Valid states include 'future' (not started), 'active' (in progress), and 'closed' (completed). States transition in this strict order. The allowed values are future, active, closed.
Goal	String	False			Common	A short statement describing the objective of the sprint. Helps align the team on what the sprint is intended to achieve.
OriginBoardId	Integer	False	Boards.Id		Common	[DEPRECATED] The ID of the agile board from which the sprint was created. Use BoardId instead. This column reports the same board and is scheduled for removal in a future release.
StartDate	Datetime	False			Common	The date and time when the sprint was officially started. Typically marks the beginning of the development cycle.
EndDate	Datetime	False			Common	The planned date and time when the sprint is expected to end. This can be used to calculate sprint duration and track timelines.
CompleteDate	Datetime	True			Common	The actual date and time when the sprint was marked as completed in Jira. Useful for reporting and retrospective analysis.
BoardId	Integer	False	Boards.Id	=	Common	The ID of the agile board the sprint originated from. Required when creating a sprint. This value is set at creation and cannot be changed. Filtering on this column restricts the query to a single board.