Epics

Lists all epics across Jira projects, including epic names, summaries, and keys.

テーブル固有の情報

本製品はJira API を使用して一部のフィルタを処理します。

本製品は他のフィルタを本製品内で処理します。

例えば、次のクエリはサーバー側でフィルタリングされます。

SELECT * FROM Epics WHERE BoardId = 1

SELECT * FROM Epics WHERE BoardId IN (1, 2, 3)

特定のエピックのId またはKey を指定：

SELECT * FROM Epics WHERE Id = 10000

SELECT * FROM Epics WHERE Id IN (10000, 10001)

SELECT * FROM Epics WHERE Key = 'TSS-9151'

SELECT * FROM Epics WHERE Key IN ('TSS-9151', 'TSS-9152')


Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	Integer		=,IN	Common	The unique numeric identifier of the Epic, used to reference the Epic internally.
Key [KEY]	String		=,IN	Common	The unique key assigned to the Epic, typically visible in the Jira user interface (such as 'EPIC-101').
BoardId [KEY]	Integer	Boards.Id	=,IN	Common	The identifier of the Jira board where the Epic is managed. This helps link the Epic to a specific agile board.
Name	String			Common	The name or title of the Epic, used to identify it in issue listings and reports.
Done	Boolean			Common	If the value is 'true', the Epic has been marked as complete. If the value is 'false', the Epic is still in progress.
ColorKey	String			Common	The color key assigned to the Epic, used to visually distinguish it from other issues in Jira boards.
Summary	String			Common	A short text summary providing additional context or a high-level overview of the Epic's purpose or goals.