ODER BY DESC in Vtiger WebServices

[David V.-2]

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 

[David V.-2]

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. <[e-mail]>

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 

[Prasad-14]

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. <[e-mail]> 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. <[e-mail]>

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 

[David V.-2]

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. <[e-mail]> 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. <[e-mail]>

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 

[Prasad-14]

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. <[e-mail]> 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. <[e-mail]> 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. <[e-mail]>

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 

[David V.-2]

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. <[e-mail]> 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. <[e-mail]> 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. <[e-mail]>

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