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

Hello everyone,

I would like to ask you if it is possible to sort alphabetically  m2o fields by its name ASC/DESC in read_group method. By default it is sorted just by database ID and I am not able to reference the name column for the field (categ_id.name ASC does not work, only categ_id ASC => sorting based on ID, see code below). Many thanks for your help!

@api.model

def read_group(self, domain, fields, groupby, offset=0, limit=None, orderby=False, lazy=True):

if 'categ_id' in groupby:

    orderby = 'categ_id.name ASC' + (orderby and (',' + orderby) or '')

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

Avatar
Discard

In read group param you have to define the order and the param based on which you wanna order(needless to say that the param needs to be present on the model being searched on). So try this:-

super(ProductTemplate, self).read_group(domain, fields, groupby, offset=offset, limit=limit, orderby="param ASC",

lazy=lazy)

Best Answer

did you find a solution?

Avatar
Discard
Related Posts Replies Views Activity
2
Oct 22
25295
1
Apr 24
1473
1
Dec 23
2740
2
Nov 22
2420
0
Nov 22
2739