[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

David V. davidv.net at gmail.com
Sat Oct 31 07:39:24 PDT 2009


Hi Vtiger developers !

Is it me or ORDER BY DESC does not work in Vtiger WebServices ?

The following query works perfectly :

    $query = "SELECT * FROM mds_computer
            WHERE id > '33x39996'
            AND data_server_ip = '".$backup_server."'
            ORDER BY computername
            LIMIT 10
            ";

This one also works but the problem is that the DESC is not taken in
account. So the query retrieves data in the same order :

    $query = "SELECT * FROM mds_computer
            WHERE id > '33x39996'
            AND data_server_ip = '".$backup_server."'
            ORDER BY computername DESC
            LIMIT 10
            ";

In the file include/WebservicesVTQL_Lexer.php.php line 133 I can see that
DESC is supported.

But in include/Webservices/VTQL_Parser.php line 307 (and also line 150) DESC
is not used.

Did anyone sucessfully make ORDER BY DESC work ?


David V.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20091031/7db5984f/attachment-0003.html 


More information about the vtigercrm-developers mailing list