Sprints
Manages Jira sprints. Supports creating, modifying, deleting, and querying sprint data from agile boards.
テーブル固有の情報
Select
Jira アカウントのSprints のリストを取得するには、BoardSprints ビューをクエリできます。
connector はJira API を使用して一部のフィルタを処理します。connector はその他のフィルタをクライアント側で内部で実行します。例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Sprints WHERE Id = 122
SELECT * FROM Sprints WHERE Id IN ('1', '2', '3')
INSERT
新しいスプリントを作成して、ボードにリンクします。新しいスプリントの挿入には、OriginBoardId およびName カラムが必須です。
INSERT INTO Sprints (OriginBoardId, Name, Goal, StartDate, EndDate) VALUES ('1', 'Inserted Sprint', 'Complete target', '2018-02-02', '2018-04-04')
Update
スプリントのId を指定してスプリントを変更します。
UPDATE Sprints SET State = 'active' WHERE Id = 305
Delete
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. 使用できる値は次のとおりです。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 |
The ID of the agile board from which the sprint was created. This value is set at creation and cannot be changed. | |
| 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. |