Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Select "All" or multi-select If, else if parameter passing issue
Migrateduser
<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>
Find more posts tagged with
Comments
There are no comments yet