Search results

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}}

Use dashboard parameter in expression column

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.

Use dashboard parameter in stored procedure

You can use the range type parameters as follows.

Range type parameter in stored procedure

Custom Query

Type @ to list the available parameters. You can use it anywhere in 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}}

Use dashboard parameter in code view

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}})