Skip to Content
Menu
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

 

Portretas
Atmesti
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.



Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
vas. 22
2154
2
kov. 24
2438
1
spal. 22
8561
1
rugs. 22
3574
0
liep. 22
3713