[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

[David V.]

Hi Prasad,

Do you have any idea about the ORDER BY ... DESC question ?
(please see below)

Thank you very much.

David V.


2009/10/31 David V. <davidv.net at gmail.com>

> 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/20091102/12ad7dcb/attachment-0003.html