Skip to Content
Menu
This question has been flagged
1 Reply
14519 Views

i want to group_by my projects with its state and the state is a selection field (initiation, implementation, execution, monitoring, testing, closure phase , closed, pending) but the problem is when i group_by the projects it grouped with alphabetical sort but i need it ordered by the same order in the selection field , could anyone help me ?

Avatar
Discard
Best Answer

In version 8

You need to override the function read_group like this:

@api.model
def read_group(self, domain, fields, groupby, offset=0, limit=None, orderby=False, lazy=True):
if 'state' in groupby:

orderby = 'state ASC' + (orderby and (',' + orderby) or '')

return super(trobz_crm_lead, self).read_group( domain, fields, groupby, offset=0, limit=limit, orderby=orderby, lazy=lazy)


Note that in case you need to order on a field many2one, the default order by field of the model will be used. However, the ASC/DESC is ignored so you will need to use a similar way as above to force the ASC/DESC.

@api.model
def read_group(self, domain, fields, groupby, offset=0, limit=None, orderby=False, lazy=True):
if 'state_id' in groupby:
orderby = 'state_id ASC' + (orderby and (',' + orderby) or '')
return super(trobz_crm_lead, self).read_group( domain, fields, groupby, offset=0, limit=limit, orderby=orderby, lazy=lazy)


Avatar
Discard
Related Posts Replies Views Activity
1
Mar 15
3775
0
Mar 15
3084
2
Nov 24
155
1
Oct 24
183
1
Jun 24
360