How to use Many2many field as a related field and use it to group by data in odoo tree view

Question

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

Cybrosys Techno Solutions Pvt.Ltd · 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 [1]

Hope it helps.

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

Bài viết liên quan	Trả lời	Lượt xem
How to 'group by' "is_win" in CRM VIEWS. Đã xử lý group_by v15	2 thg 2 22	2258
How to make Many2many Field as read only? Đã xử lý readonly many2many_tags v15	2 thg 3 24	2627
How to create Read Only tree view in odoo 15? readonly tree_view v15	1 thg 10 22	8781
Custom group by group_by filters v15	1 thg 9 22	3743
How Can I Make Group by in one2many field group_by v15 @one2many	0 thg 7 22	3881

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!