Dashboards
Retrieves dashboards available to the user, including those shared with others or marked as favorites.
Table Specific Information
Select
The add-in 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 add-in processes other filters within the add-in.
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 unique identifier assigned to the dashboard within Jira. This ID is used to reference the dashboard programmatically. | |
| Name | String | Common | The display name of the dashboard, visible to users in the Jira interface. | ||
| View | String | Common | The direct URL that allows users to view the dashboard in the Jira interface. |
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 | An optional filter to limit the results to specific categories of dashboards. For example, 'favourite' shows dashboards marked as favorites, while 'my' shows dashboards owned by the current user.
The allowed values are favourite, my. |