Parameters

Queries with parameters enable you to vary the results based on input values without disturbing the text of the underlying query. Basically, any string enclosed by double curly brackets {{ }}is known as a parameter. The use of parameters in Query enables users to reuse a single instance of that query over and over again, passing different parameters values at execution time.

Data Types

When you query the data source using multiple parameters you must select a data type that supports the value. For example, a database column that contains only date values is formatted as a DATE, a spreadsheet column that contains string values is formatted as a TEXT.

Supported Data Type
TEXT
Numeric
DATE
TIMESTAMP
BOOLEAN
LIST
INTEGER
DECIMAL
NATURAL DATE

You can add the parameters in Query as well as the visual mode in Boltic.

Add Parameters to Visual Mode

Add Parameters to Query Mode

Run Time Parameters

Run Time Parameters gives you the flexibility to change the parameter values at run time even after you have created a parameterized Bolt.