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.