[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

David V. davidv.net at gmail.com
Tue Nov 3 01:49:23 PST 2009


Thank you Prasad.

David V.


2009/11/3 Prasad <prasad at vtiger.com>

> 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
>>
>
>
> _______________________________________________
> 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/16975336/attachment-0003.html 


More information about the vtigercrm-developers mailing list