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 )
Last modified: Apr 18, 2023

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment