Manage SQL Queries

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.6 u5 > Dashboards and Reports Customization Guide > Designing Dashboards > Provide Data > Working with SQL Data Sources 

Manage SQL Queries

After you connect to the data source and select the required data, you can create new SQL queries or edit the existing queries in the SQL data sources. To manage data sources, open the dashboard menu and go to the Data Sources page.

 

WDDDataSourcePage

 

To add a new query, click the Add Query button. This invokes the Dashboard Data Source Wizard, where you can create a query, select a stored procedure, or configure query parameters.

To edit an existing query, click the query's Edit button (the edit icon) in the Field List. This action invokes the Dashboard Data Source Wizard.

To delete an existing query or calculated field from a dashboard SQL data source, click the query's Delete button (the DeleteDataSource).