Skip to Content
Menu
This question has been flagged
2 Replies
14850 Views

Hello, I have Odoo 8.

I need to add a "group by" button in a report. I know that the XML code is like this:

<filter name="groupby_name" context="{'group_by': 'field''}" string="Description" />

But I have a model A on where I do the group by and this model has a many2one relation with a model B. The attribute of the many2one relation is named "rel". If I need to group by over any field of model B, how can I do? If I write

<filter name="groupby_name" context="{'group_by': 'rel.name_field''}" string="Description" />

But when I press the button to grupo by I get: TypeError: this.fields[field] is undefined

How can I do this groupby? Thanks!

Avatar
Discard
Best Answer

Hello Jose,

Related field field by default it will not store in the Database, so you have to pass store=True argument while declare the field on python, after that you can able to do group by.

Avatar
Discard
Best Answer

take related field:

e.g.

rel = fields,many2one('modelB')

field_use_in_filter = fields.field_type(related='rel.field_name')

and then use it in a filter 

Avatar
Discard
Related Posts Replies Views Activity
7
May 20
6238
0
Apr 16
2947
2
Apr 15
5791
11
Sep 21
31925
2
Mar 25
8384