ADO.NET Provider for Jira

Build 23.0.8839

Epics

Query all the Epics.

Table Specific Information

Select

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') 

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 23.0.8839