openerp-india team mailing list archive

["Olivier Laurent \(Acsone\)" <olivier.laurent@xxxxxxxxx>]

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