Pass Query Parameters

<< Click to Display Table of Contents >>

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

Pass Query Parameters

The Query Builder allows you to filter queries using parameters. To specify settings of an added query parameter after creating a query, click Next in the Dashboard Data Source Wizard dialog.

 

wddConfigureQueryParameters

 

On the next page, select the query parameter you have created to configure it.

 

wddconfigurequeryparameterspage2

 

The following settings are available.

 

Name - Specifies a parameter's name.

Type - Specifies the parameter's type.

Value - Specifies the parameter's value. If the parameter type is set to Expression, invoke the Expression Editor dialog using the ellipsis button and specify the required expression. For example, you can use an existing dashboard parameter to pass to the SQL query.

 

Use Add to add a new parameter and the Remove button to remove the selected query parameter.

 

Then, click Finish to complete query modifications.