Administrators can manage dashboard queries through a dedicated section at admin settings or through the widget editor itself. Both ways will be discussed in the following sections
Managing the Query (Widget editor)
Creating A New Query
1. From the widget setting page, click on the "create new query" link under Select Query section.
2. From the create query window, Supply the query name and the actual SQL query.
Clicking on OK button will save the query details onto the Datasource table at ServiceManagement database.
Editing the Selected Query
1. From the widget setting page, click on the "edit selected query" link under Select Query section.
2. From the edit query window, do the desired modification on the query
Clicking on OK button will update the query details onto the Datasource table at ServiceManagement database. Keep in mind that any changes made to the selected query will affect all the dashboards that use it.
Converting Legacy Queries
Queries created prior to version 7.4.1 are still accessible and can be modified through the edit selected query option. To convert the configuration to the new format, simply edit the query and give it a name (a required field).
Managing the Query (Dashboard query settings page)
Dashboard Query Settings
Administrators can manage the queries from a admin setting page, which can be access through Admin Settings->Dashboard Query Settings.
The collection of query information are presented in a table or grid format. The queries that have no name in them refers to queries that were used on the legacy dashboard pages.
By default the Id column is hidden out and can be viewed by ticking the checkbox for the Id option on grid's column menu settings.
Creating A New Query
From the drawer menu, click on the Add button and supply the query details - Name, DataSource, and the actual SQL Query on the create new window. Click on Save to save the changes.
By default, DataSource is set to the ServiceManagement database.
Editing A Query
Select a row from query grid and click on Edit button found at the drawer section. That should open up the edit window filled with query's recent details. Update details on that window and click on Save to save the changes.
Deleting A Query
Select a row from query grid and click on Delete button found at the drawer section.
Only queries that are not used anywhere are allowed to be deleted. If the selected query to delete is still in use, user will be prompted with this warning message:
