Xacute query's output parameters in 14.0 SP5

[Former Member]

Hi,

I have selected * as the output parameter of my xacute query but when I try to get the values of different parameters in javascript, it gives me a blank. However, if I select one specific parameter as the output parameter, my javascript code returns its value.

Example:

Xacute's Output Parameter -  *

Code: document.iCommandName.getValueByName("TestVar1",1);      -     Returns blank

          document.iCommandName.getValueByName("TestVar2",1);      -     Returns blank

Xacute's Output Parameter - TestVar1

Code: document.iCommandName.getValueByName("TestVar1",1);     -     Returns correct value

Is this a known issue in 14.0 SP5? Pointers on this are highly appreciated.

Thanks & Regards,

Anuj

[swaroop_anasane · Accepted solution]

Hi Anuj,

Are you passing an output as xml? Quite a usual scenario in SP05 with xacute having multiple output parameters with one xml.

However,this should not be an ideal way MII responds, it looks like a bug.

I am personally waiting for some patch/fix for this one. Which patch are you using?

Workaround: You can create an xml document and append outputs so that you get a single xml output parameter from xacute out of which you can retrieve specific values.

Hope this helps.

Thanks and Regards,

Swaroop

[Former Member · Accepted solution]

Hi Swaroop,

Thanks for your reply.

Yes, there are 2 output parameters of XML data type in my Xacute query.

I now have the idea that its an issue with the current version of MII I am using and will do the work around for that, as the scenario in my case is different and I cannot create one single xml with multiple output parameters.

Best Regards,

Anuj

[swaroop_anasane · Accepted solution]

Hi Anuj,

That's great that you have a work around.

Warm Regards and a Very happy new year in advance,

Swaroop

[former_member185280 · Accepted solution]

If both output parameters are xml then it may be working as intended.

OutputParameter

Returns a specific transaction property value from a transaction. If you use an asterisk, all non-XML data type transaction property values are returned. XML transaction variables must be returned one at a time by explicitly referencing them with this parameter. If the output parameter is of type XML, and does not adhere to SAP MII format, then the result of the query can only be viewed in a browser by changing its content type to text/xml.

[swaroop_anasane · Accepted solution]

Hi Chris,

Thanks for highlighting.

So basically,in such a scenario, the help would be by appending the outputs as Rowset to the Rowsets node.

I confused it with a scenario where we were calling a SP from fixed query.

The SP was so written that it gave no. of rows affected as first result string and select result as a grid. In such a case, query template was giving a blank output with no data, not even column names.

This is a bug right?

Thanks,

Swaroop

[swaroop_anasane · Accepted solution]

Hi Chris,

Also,request you to check the below thread and let me know if my understanding on the topic is correct or I am facing a bug! If so, i would like to raise a ticket for this.

Thanks in advance.

Thanks,

Swaroop