Epics

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

Table Specific Information

The provider uses the Jira API to process some of the filters.

The provider processes other filters within the provider.

For example, the following queries are filtered server-side:

SELECT * FROM Epics WHERE BoardId = 1

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

By specifying the Id or Key of a certain epic:

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.