How to give some default value in checkbox Pulldown if nothing is selected

[JaideepK]

I am using a checkbox Pulldown and using

I am using "MyValue" to pass the selected values in the checkbox Pulldown to MYSQL query as an OR condition.

ex: select * from abc wherer name = 'xyz' OR $MyValue$

but the problem is, if no value is selected in the checkbox Pulldown nothing is being passed by $MyValue$ and the query looks as shown below and is not able to execute

ex: select * from abc wherer name = 'xyz' OR

[sideview · Accepted solution]

You can pull up the "OR " part into the "outerTemplate" param like so:

<param name="outerTemplate">OR ($value$)</param>

and then when there are no terms to output and $MyValue$ dissappears, the OR will disappear with it.

[JaideepK]

Thank you so much for the fast reply it worked for me....