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
Multi value parameter Cascading parameters
Migrateduser
Hi I am trying to pass multi value parameters using cascaded parameter that is p_service and p_subtype. My goal is to get related resultset from select statement using IN clause .<br />
My SQl is <br />
select distinct DMW_WORK_ORDER.MGE_CD_FO_SUB_TYP, DMW_WORK_ORDER.MGE_CD_FO_TYP<br />
from DMW_WORK_ORDER <br />
<br />
and I have wrote this in beforeOpen script:<br />
<br />
var parmcount = params["p_service"].value.length<br />
var whereclause = "";<br />
if ( parmcount > 0 ){<br />
whereclause = " where DMW_WORK_ORDER.MGE_CD_FO_TYP in ('"<br />
}<br />
for ( i=0; i < parmcount; i++ ){<br />
if( i == 0 ){<br />
whereclause = whereclause + params["p_service"].value
;<br />
} else {<br />
whereclause = whereclause + "' , '" + params["p_service"].value
; <br />
}<br />
}<br />
if ( parmcount > 0 ){<br />
this.queryText = this.queryText + whereclause + "') ";<br />
}<br />
<br />
If I use this:<br />
this.queryText = this.queryText + " where DMW_WORK_ORDER.MGE_CD_FO_TYP IN ('" + params["p_service"].value + "')";<br />
I can select one value and get resultset in other cascaded parameter that is p_subtype<br />
<br />
but since i need all the value related with selected service which can be more than one ,( when i select more than one service parameter), I get empty . I feel something wrong with the script but i cant figure out why it is doing this .<br />
Help will be much apreciated.<br />
thanks
Find more posts tagged with
Comments
There are no comments yet