Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged

category_ids = fields.Many2many(related='employee_id.category_ids', string='Tags')


In XML tree view:

 


I have tried the above. it's working fine. I can filter the data using category_ids.

But I can't group by using category_ids! I have tried using store=True. but it gives me below error:

psycopg2.errors.UndefinedTable: relation "none" does not exist

 

Avatar
Opusti
Best Answer

Hi,

You cannot group by many2many fields in Odoo. When you provide a group by filter using a many2many field, You will get an error message like Assertion error.To provide a group by filter using many2many fields

Try refer the blog:

https://www.cybrosys.com/blog/how-to-use-group-by-for-many2many-fields-in-odoo-16


Hope it helps.



Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
2
feb. 22
2151
2
mar. 24
2428
1
okt. 22
8557
1
sep. 22
3571
0
jul. 22
3710