Error with Power BI connector after DB upgrade 18.2

Question

I am using a connector provided by tmijail on github.
https://github.com/tmijail/Odoo-Power-BI-Connector
Our DB was upgraded to 18.2 last night and now none of my search read queries work.  Anyone have a similar issue and know how to fix it?  Thank you for any advice on this issue!

Odoo Server Error: Invalid field res.groups.users in condition ('users', '=', 16) Details:     Traceback (most recent call last):   File "/home/odoo/src/odoo/saas-18.2/odoo/orm/domains.py", line 768, in __get_field

Christoph Farnleitner · Accepted Answer

In the model /res.groups/ the field /users/ got refactored to /user_ids/ - see  https://github.com/odoo/odoo/blob/saas-18.2/odoo/addons/base/models/res_groups.py#L14 [1] compared to https://github.com/odoo/odoo/blob/18.0/odoo/addons/base/models/res_users.py#L184 [2] . - in, what I would assume, an effort to unify field naming and applying commonly used conventions (i.e. a field related to another model is named *_id for a /Many2one/ and *_ids for a /One/- or /Many2many/ relationship).
To fix thi

Chad Sullivan · Answer

Thank you for the help and pointing that out.
In the Odoo.mez file I was able to update the odoo.pq and fix the line of code that was referencing the refactored field.  Once that was done all queries are back to normal in Power BI desktop and online via the Power BI service.

*OLD CODE:*
{"group_id.users", "=", _uid}, {"group_id", "=", false} }
*NEW CODE:*
{"group_id.user_ids", "=", _uid}, {"group_id.user_ids", "=", false} }

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!