Dashboards
Query the available Dashboards in Jira.
Table Specific Information
Select
The component 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 component processes other filters within the component.
For example, the following queries are processed server side.
SELECT * FROM Dashboards WHERE Id = 10001You 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. |