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.
Use <orderBy/> on the field, e.g.:
The tables will have to have their relations already defined in schema def.