searchCriteria and sorted return data

Version 1
    This document was generated from CDN thread

    Created by: Doug Kartio on 21-08-2013 07:46:15 AM
    When making a listXXX call.  Is it possilbe to have the data come back in a particular order.

    Example:  If I was to make a normal sql call to return the locations of a particular cluster, I could make the call
    "select pkid, name from location order by name"

    using the new listXXXXX  AXL call, I do this:
    <axl:listLocation xmlns:axl="http://www.cisco.com/AXL/API/9.0" sequence="1">
    <searchCriteria><name>%</name></searchCriteria>
    <returnedTags><id/><name/></returnedTags>
    </axl:listLocation>

    How can I set the ORDER BY?

    Thanks

    Subject: RE: searchCriteria and sorted return data
    Replied by: David Staudt on 21-08-2013 08:54:25 AM
    listXXX requests do not provide a sort/order mechanism...this is for performance reasons.  For the same reasons, it is highly recommended that executeSqlQuery requests do not specify ordering, calculations or other extraneous data-manipulation by the UCM database engine - it is better to perform these operations on a separate, non-realtime-critical system after the raw data is retrieved from UCM.