Hi there,

Does anyone know of a way to order a result set by a specified field when using Sage CRM web services? I've tried with `query`, `queryentity`, `queryidnodate`, and `queryrecord`, and all of them return an error.

As an example, I'm constructing my query string like so:

comp_updateddate > '2018-04-14' order by comp_createddate desc

Any ideas?

I'm getting the following XML payload back. It should be noted that I'm not a Sage admin, and only have access to Sage via its web interface, and the SOAP API.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="">schemas.xmlsoap.org/.../" xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../" xmlns:xsi="">www.w3.org/.../XMLSchema-instance">
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Server</faultcode>
<faultstring>Query failed to run successfully.
</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>