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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

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.