Pass Query Parameters
A query parameter holds an external value that is inserted into an SQL statement before query execution. This value c be static or dynamically generated by an associated expression.
The query parameter value is inserted into the resulting SQL query string in the @QueryParameterName placeholde position.
In dashboards, query parameters are used in the following scenarios:
-> When filtering dashboard data on the data source level using the Query Builder.
-> When binding a dashboard to a stored procedure an SQL data source provides.
You can access query parameters using the Parameters property of the query the dashboard’s SqlDataSource component exposes. These parameters include the ones you created within the Query Builder or that were generated the data source’s stored procedure.
Configure Query Parameters
The Query Editor dialog contains the added query parameters’ settings.
Name - Specifies a parameter's name.
Type - Specifies the parameter's type.
Expression - Specifies whether an expression is used to specify a parameter's value.
Value - Specifies the parameter's value. If the Expression check box is checked, you can invoke the Expression Editor dialog to specify the required expression or select an existing dashboard parameter to pass to the SQL query.
