Uses of Dashboard parameters

The dashboard parameters can be used in the expression, stored procedures and custom query.

Expression

Select the parameter from the Column Settings or use the following syntax to create a expression with dashboard parameter.

Syntax: @{{:ParameterName}}

For range type parameter, syntax should be provided as follows.

Syntax:@{{:ParameterName.START}} or @{{:ParameterName.END}}

NOTE: Those parameters, which are created using the list mode, will not be used in expression.

Stored Procedure

Choose the parameter option from the stored procedure parameter window. Available parameter will be listed in value drop-down box.

You can use the range type parameters as follows.

Data Filter

You can use parameters in the Data filter to filter records. To configure the Data filter, refer to the configuring data filters section.

Custom Query

Type @ to list the available parameters. You can use it anywhere in the query editor window.

Another way is, user can manually type the required parameter in code view using the syntax.

Syntax: @{{:ParameterName}}

For range type parameter, syntax should be provided as follows.

Syntax: @{{:ParameterName.START}} or @{{:ParameterName.END}}

Conditions to use list-mode type with multiple selected values

Expression: You can prefer the ‘CONCAT’ function.

Example: CONCAT([Parameter1])

Stored Procedure: You should create a stored procedure using the logic trick. Because SQL stored procedure accepts only a single object as a parameter. However, you can pass multiple values as comma separated single strings to the parameter by a trick.

Custom Query: You can use this dashboard parameter with multiple values only using IN query.

Example: Select * from Table_Name where ColumnName in (@{{:ParameterName}})