topic Re: How to give some default value in checkbox Pulldown if nothing is selected in All Apps and Add-ons

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

JaideepK — Wed, 18 Jun 2014 16:31:57 GMT

I am using a checkbox Pulldown and using

MyValue
a.appId="$value$"

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

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

sideview — Wed, 18 Jun 2014 16:33:54 GMT

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.

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

JaideepK — Wed, 18 Jun 2014 16:50:11 GMT

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