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)
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)