Using Parameters

Parameters can be used to parametrize a Custom Query : the Custom Query changes dynamically.

Syntax

${parametername} will be replaced in-place by the values of “parametername”.

Example :

SELECT *
FROM MyTable
WHERE MyColumn = ${parametername}

will get replaced at runtime by :

SELECT *
FROM MyTable
WHERE MyColumn = parametervalue

Multiple values

Parameters that return multiple values will return them separated with commas.

So that you can write :

SELECT *
FROM MyTable
WHERE MyColumn IN( ${multiparameter} )

and it will get replaced at runtime by :

SELECT *
FROM MyTable
WHERE MyColumn IN( Value1,Value2,Value3 )

*NOTE
In Alpana Designer, the Custom Query will be executed with the default parameter values. This may cause unwanted syntax errors if the default value is empty for example.
Setting a default value to the parameter fixes that issue.