Skip to Content
0
Former Member
Feb 15, 2011 at 05:52 PM

Unable to pass variables from IRPT to on demand MDO in MII v12.2

128 Views

Hi all,

Here is what I am trying to achieve - to pass an order input value from front end and fetch the results through on demand MDO.

STEP 1: Created a BLS transaction with input parameter order and tested it to get Output XML - SUCCESSFUL.

STEP 2: Created an On-Demand MDO object pointing to the BLS transaction, tested it by passing the value to input parameter in Dynamic Query Parameters - SUCCESSFUL.

STEP 3: Created an MDO Query Template in SELECT mode pointing to the MDO object created, there are 2 things which I noticed. when I pass the value to OBJECT PARAMETER, it worked fine and when I pass it to PARAMETERS it Doest not work. I just used the object parameter because it worked for me.

STEP 4: Created an Applet with MDO Query Template and Grid Display template. Tried passing the value using setParam(1, order). I found 3 different variations:

Result 1: If Object Parameter in MDO Query is not set to any default value - "No Data Available" is seen on applet.

Result 2: If Object Parameter is set to some valid default value say 123, irrespective of what I pass from UI setParam, I always see the data of 123.

Result 3: If Object Parameter is set to some valid default value say 123 and in addition to that, I add Filter expression [val1] = [ param (dot)1 ] in my MDO select query, then when I pass 123 from UI, I see the result and when I pass someother input I see empty table, however now I can see the columns with empty table.

Can someone tell me where I am going wrong?

Any help is highly appreciated.