Epics

Query all the Epics.

Table Specific Information

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

The driver processes other filters within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

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 Id of the Epic.
Key [KEY]	String		=,IN	Common	The key of the Epic.
BoardId [KEY]	Integer	Boards.Id	=,IN	Common	The board Id the Epic is in.
Name	String			Common	The name of the Epic.
Done	Boolean			Common	Whether or not the Epic is done.
ColorKey	String			Common	The key of the Epic's color.
Summary	String			Common	A brief summary for the Epic.