cannot search() entries with order "id DESC"

[Florent]

Hello,

I've experienced this bug both with 6.1 and with trunk.
When using the optional argument "order" for the osv method search(), the choice "id DESC" will sort ascending (like "id ASC" or plain "id").
It is not possible to sort by "id DESC".

The issue is in openerp.osv.orm.BaseModel._generate_order_by(...).

When the field is "id", the direction is not taken into account.
http://bazaar.launchpad.net/~openerp/openobject-server/trunk/view/head:/openerp/osv/orm.py#L4616

Please fix it for the supported branch 6.1 and for trunk.

--
Florent

[Florent (florent.x)]

The issue is also visible when clicking the header "ID" of the column in tree view: it never sorts descending.

The "_order" attribute of BaseModel is not affected. If you put _order='id DESC', the entries are displayed in descending order.
However, as soon as you click the header "ID", the direction "descending" is lost.

[Florent (florent.x)]

version 5.0 is not affected --> this is a regression

This is why I've put OPW noisy. This is impacting our system upgrade.

[Ravi Gohil (OpenERP) (rgo-openerp)]

Fix landed into main Stable V6.1 branch with,
Rev. id: <email address hidden>
Rev. no: 4278

Thanks.

[SnippetBucket.com (tta-openerp)]

Hello Florent,

This bug have been Fixed.

 * It has been Fixed in https://code.launchpad.net/~openerp-dev/openobject-server/trunk-bug-1044341-tta
 * Revision ID: <email address hidden>

  It will be available soon in trunk.

Thanks,
Tejas - tta

[Amit Parik (amit-parik)]

Landed on trunk at revision 4743.1.205

Thank you!