[Vtigercrm-developers] ODER BY DESC in Vtiger WebServices

David V. davidv.net at gmail.com
Tue Nov 3 03:21:09 PST 2009


Ok Prasad. I'll do it asap.

Thanks again.

David V.


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

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


More information about the vtigercrm-developers mailing list