Hello OpenERP Team,

Any news about the fixing of this issue ?

The bug is located in the read_group method of the BaseModel in orm.py arround 
this line of code:
    data_ids = self.search(cr, uid, [('id', 'in', alldata.keys())], 
order=order, context=context)
that tries to introduce the sort _AFTER_ the fetch of data rows with the sql 
query that preceeds.

Unfortunately, the domain passed to the search method is based on a
collection of aggregate ids (i.e. min(id)) for which the sort is made on
their own fields values _NOT_ on the aggregate values computed by the
sql query.

It would be better to introduce the sort directly in the sql query with
a classic "ORDER BY" clause.

Many thanks in advance for the fix.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1060086

Title:
  sorting in report view

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  Hello,

  In the sale report view, when i try to sort by "total price" (it's
  does'nt work with other fields either), the sorting is incorrect.

  So I can't see my best partner (for example)

  I don't have the problem with classic tree view.

  See the screeshot attached.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1060086/+subscriptions

_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help   : https://help.launchpad.net/ListHelp

Reply via email to