Select "All" or multi-select If, else if parameter passing issue

abrumar

<p>This code returns data as expected for one or several selected parameter values (!= "All") but NO data if "All" is selected.  In looking at logs, when "All" is selected "not equal to" code is passed to queryText.</p>
<p> </p>
<div>if (params["Region"] != "All")</div>
<div>{</div>
<div>this.queryText = this.queryText +</div>
<div>" WHERE zone_code IN ('"+params["Region"].value.join("','")+"')" +</div>
<div>" AND zone_code_sub LIKE concat (zone_code, '%')"</div>
<div>}</div>
<div> </div>
<div>else if (params["Region"] == "All")</div>
<div>{</div>
<div>this.queryText = this.queryText +</div>
<div>" WHERE zone_code LIKE '%'"+</div>
<div>" AND zone_code_sub LIKE concat (zone_code, '%')"</div>
<div>};</div>
<div> </div>
<div>Running BIRT4.3.1</div>
<div> </div>
<div>"Region" parameter is dynamic with "All" set as default.</div>

micajblock

<p>Multi select parameters are arrays (hence the join in your code). Try:</p>
<pre class="_prettyXprint">
params["Region"].value[0] == "All"</pre>