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

View-Specific Information

SELECT

The driver uses the Jira API to process filters based on the BoardId column. The driver processes all other filters client-side.

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

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

Columns

Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	Integer			Common	The unique numeric identifier of the Epic, used to reference the Epic internally.
Key [KEY]	String			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	Indicates whether the Epic has been marked as complete.
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.