Sprints

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

テーブル固有の情報

Jira アカウントのSprints のリストを取得するには、BoardSprints ビューをクエリできます。

本製品はJira API を使用して一部のフィルタを処理します。本製品はその他のフィルタをクライアント側で内部で実行します。例えば、次のクエリはサーバー側で処理されます。

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

新しいスプリントを作成して、ボードにリンクします。新しいスプリントの挿入には、OriginBoardId およびName カラムが必須です。

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

スプリントのId を指定してスプリントを変更します。

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

Id を指定して、スプリントを削除します。

DELETE FROM Sprints WHERE Id = 305


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.