ORM search based on jsonb field

Question

How to query a model based on a jsonb field?
e.g.
action_scrap_orders = request.env['ir.actions.actions'].sudo().search([('type', '=', 'ir.actions.act_window'), ('name["en_US"]', '=', 'Scrap Orders')], limit=1)
Raises
❌
ValueError: Invalid field ir.actions.actions.name["en_US"] in leaf ('name["en_US"]', '=', 'Scrap Orders')

SSSE/SIG, Luca Palo · Answer

Thank you  Ray Carnes (ray) It works!

Ray Carnes (ray) · Answer

action_scrap_orders = request.env['ir.actions.actions'].with_context(lang='en_US').sudo().search([
('type', '=', 'ir.actions.act_window'),
('name', '=', 'Scrap Orders')
], limit=1)

相关帖文	回复	查看
ORM Query Search 已解决 orm query	7 4月 22	16830
Execute query when installing addon 已解决 modules addons orm query	2 5月 18	12311
Available Serial numbers for move lines orm query browse fetch	0 3月 15	6561
Odoo Performance Discussion: Slow Dashboards, Reports & Repeated Data Access postgresql orm query odoo indexing	0 4月 26	710
How can employees easily manage corporate card receipt uploads v18	0 12月 25	39

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！