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
optional parameter
Migrateduser
<p>Hi...i have created a four parameter like product line,country,state,city now i have to pass parameter in before-open like </p><div><pre class="_prettyXprint">if (params["productline"].value && params["country"].value){q1=this.queryText = this.queryText + " AND PRODUCTLINE = '" + params["productline"].value +"'"+" and COUNTRY = '" + params["country"].value + "'"+"group by country,state,city,productline,buyprice,msrp,CLASSICMODELS.ORDERS.ORDERDATE"; Packages.java.lang.System.out.println ("Query1:" +q1);}else if (params["productline"].value && params["state"].value ){q2=this.queryText = this.queryText + " AND productline = '" + params["productline"].value +"'"+" and state = '" + params["state"].value + "'"+ " group by country,state,city,productline,buyprice,msrp,CLASSICMODELS.ORDERS.ORDERDATE";Packages.java.lang.System.out.println ("Query2:" +q2);}else {q3=this.queryText = this.queryText + " AND productline = '" + params["productline"].value +"'"+" and city = '" + params["city"].value + "'"+ " group by country,state,city,productline,buyprice,msrp,CLASSICMODELS.ORDERS.ORDERDATE";Packages.java.lang.System.out.println ("Query3:" +q3);}</pre><p>i had unchecked the is-required option its pass well but null value is present in list box ..</p><p>So Now user can select any parameter like </p><p> </p><p>i) product line and country</p><p>ii) product line and state</p><p>iii) product line and city</p><p> </p><p>is this way correct way or is there some other way???can body help on this....</p></div>
Find more posts tagged with
Comments
There are no comments yet