Epics
Query all the Epics.
Table Specific Information
Select
The component uses the Jira API to process some of the filters.
The component processes other filters within the component.
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')
Columns
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. |