Odoo Help


Order in groupby view

on 2/4/15, 11:16 AM 1,177 views


I can manage ordering in a tree view with "_order = xxx" option in an object, but when I use a group by filter, this order is lost.

I have to order a column by hand to keep this order on the groupby view.

Does anyone know how to set an order by in a group by filter used by default?



Cyril Gaspard (GEM)
On 2/5/15, 8:53 PM

Hi, try to override this method with orderby attribute you want :


read_group(cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False)

Get the list of records in list view grouped by the given groupby fields


  • cr -- database cursor

  • uid -- current user id

  • domain -- list specifying search criteria [['field_name', 'operator', 'value'], ...]

  • fields -- list of fields present in the list view specified on the object

  • groupby -- list of fields on which to groupby the records

  • offset -- optional number of records to skip

  • limit -- optional max number of records to return

  • context -- context arguments, like lang, time zone

  • order -- optional order by specification, for overriding the natural sort ordering of the groups, see also search() (supported only for many2one fields currently)

It works! I search for my group by vue in groupby argument, then I set a value to order_by on the colums I want. Thanks a lot, David

on 2/6/15, 3:20 AM
On 2/5/15, 10:30 AM

As fas as I know, I dont think you can set ordering criteria on group by... if you had noticed,  in the database query level only when you have aggregate functions/group by clause, you cannot straight way order it on the resultant data..

hence same way happens in odoo group by also...

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 2/4/15, 11:16 AM
Seen: 1177 times
Last updated: 3/16/15, 8:10 AM