BoardSprints
Query the agile Sprints related to a Jira Board.
Table Specific Information
Select
The cmdlet uses the Jira API to process some of the filters. The cmdlet processes other filters within the cmdlet.
For example, the following queries are processed server side.
SELECT * FROM BoardSprints WHERE BoardId = 122
Using BoardId:
SELECT * FROM BoardSprints WHERE BoardId IN (12, 42)
Boards of type 'kanban' do not support sprints, so you can retrieve all the sprints faster if you use a query like the following:
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 Id of the sprint. | ||
| BoardId [KEY] | Integer |
Boards.Id | =,IN | Common | The board Id the sprint is in. |
| Name | String | Common | The name of the sprint. | ||
| State | String | = | Common | The state of the sprint. The sprint state can only transition from 'future' to 'active', and from 'active' to 'close'
The allowed values are future, active, closed. | |
| Goal | String | Common | The goal assigned for the sprint. | ||
| OriginBoardId | Integer |
Boards.Id | = | Common | The board Id the sprint originated from. This field cannot be updated |
| StartDate | Datetime | Common | The date when the sprint was started. | ||
| EndDate | Datetime | Common | The date when the sprint has ended. | ||
| CompleteDate | Datetime | Common | The date when the sprint was completed. |