Retrieves a list of sprints associated with a specific agile board, including active, future, and closed sprints.

View-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the BoardId column. The add-in processes all other filters client-side.

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

SELECT * FROM BoardSprints WHERE BoardId = 122;
SELECT * FROM BoardSprints WHERE BoardId IN (12, 42);
SELECT * FROM BoardSprints WHERE BoardId IN (SELECT Id FROM Boards WHERE Type != 'kanban');

Columns

Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	Integer			Common	The unique identifier of the sprint used to reference the sprint within Jira.
BoardId [KEY]	Integer	Boards.Id	=	Common	The identifier of the board the sprint belongs to. Sprints are created and managed within the context of a board.
Name	String			Common	The user-defined name of the sprint, typically representing a time-boxed development iteration.
State	String		=	Common	The current lifecycle state of the sprint. The allowed values are future, active, closed.
Goal	String			Common	The goal or objective defined for the sprint, often used to communicate the sprint's focus or expected outcome.
OriginBoardId	Integer	Boards.Id	=	Common	The identifier of the board where the sprint was initially created. This value is read-only and cannot be changed.
StartDate	Datetime			Common	The date and time when the sprint was started, marking the beginning of the sprint duration.
EndDate	Datetime			Common	The scheduled end date and time of the sprint, representing the planned close of the sprint window.
CompleteDate	Datetime			Common	The actual completion date of the sprint. This field is set when the sprint is officially closed.