[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

[Prasad]

David,

Please report it on trac.vtiger.com

On 11/3/09, David V. <davidv.net at gmail.com> wrote:
>
> 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
>>
>
>
> _______________________________________________
> 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/ceb18891/attachment-0003.html