SOAP call Response sort based on linked table field

udays9774551

07-04-2020

I have a requirement to sort based on a field from a linked table in the output of a soap call(wsdl). I am using queryDef ExecuteQuery method.

 

This field is available in Table C. Table C is linked to Table B and Table B is linked to Table A. We are using Table A to query in Soap call.

We are able to order with the field available in Table A but how to order the results based on the field available in Table C.

 

Please let me know if you any idea. Thank you in advance.

 

Regards,

Uday Sakhre

Adobe Campaign Classic Adobe Campaign Standard SOAPUI

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

08-04-2020

Hi,

 

Use <orderBy/> on the field, e.g.:

<orderBy>
  <node expr="[tableA/tableB/tableC/@sortField]"/>
</orderBy>

 

The tables will have to have their relations already defined in schema def.

 

Thanks,

-Jon

Answers (0)