ODBC Driver for Jira

Build 24.0.8963

Epics

Query all the Epics.

Table Specific Information

Select

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

The driver processes other filters within the driver.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963