JDBC Driver for Jira

Build 23.0.8839

Dashboards

Query the available Dashboards in Jira.

Table Specific Information

Select

The driver uses the Jira API to process some of the filters. Jira supports the Id and Filter columns but not both at the same time.

The driver processes other filters within the driver.

For example, the following queries are processed server side.

SELECT * FROM Dashboards WHERE Id = 10001
You can also filter on the pseudo column Filter:
SELECT * FROM Dashboards WHERE Filter = 'favourite'

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] String = Common The Id of the dashboard.
Name String Common The name of the dashboard
View String Common The view URL of the dashboard.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Filter String This is used to filter data. Valid values include favourite and my.

The allowed values are favourite, my.

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