BoardSprints
Query the agile Sprints related to a Jira Board.
テーブル固有の情報
Select
connector はJira API を使用して一部のフィルタを処理します。connector は他のフィルタをconnector 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM BoardSprints WHERE BoardId = 122
BoardId の使用：
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 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'
使用できる値は次のとおりです。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. |