[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

Prasad prasad at vtiger.com
Mon Nov 2 21:35:07 PST 2009


Hi David,

As you pointed out DESC rule has been skipped in the lexer, you will need to
add it and re-build the parser file.

Regards,
Prasad

On 11/2/09, David V. <davidv.net at gmail.com> wrote:
>
> 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.
>>
>
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20091103/7e4b879e/attachment-0003.html 


More information about the vtigercrm-developers mailing list