ODER BY DESC in Vtiger WebServices

View: New views
6 Messages — Rating Filter:   Alert me  

ODER BY DESC in Vtiger WebServices

by David V.-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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 

Re: ODER BY DESC in Vtiger WebServices

by David V.-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@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 

Re: ODER BY DESC in Vtiger WebServices

by Prasad-14 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
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@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@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 

Re: ODER BY DESC in Vtiger WebServices

by David V.-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thank you Prasad.

David V.


2009/11/3 Prasad <prasad@...>
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@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@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 

Re: ODER BY DESC in Vtiger WebServices

by Prasad-14 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
David,

Please report it on trac.vtiger.com

On 11/3/09, David V. <davidv.net@gmail.com> wrote:
Thank you Prasad.

David V.


2009/11/3 Prasad <prasad@...>

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@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@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 

Re: ODER BY DESC in Vtiger WebServices

by David V.-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok Prasad. I'll do it asap.

Thanks again.

David V.


2009/11/3 Prasad <prasad@...>
David,

Please report it on trac.vtiger.com


On 11/3/09, David V. <davidv.net@gmail.com> wrote:
Thank you Prasad.

David V.


2009/11/3 Prasad <prasad@...>

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@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@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


_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com