Skip to Content
This question has been flagged
ormqueryv18
2 Respostes
594 Vistes
Avatar
SSSE/SIG, Luca Palo

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')

Avatar
Descartar
Avatar
SSSE/SIG, Luca Palo
Autor Best Answer
Thank you 
Ray Carnes (ray)

It works!

Avatar
Descartar
Avatar
Ray Carnes (ray)
Best 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)


Avatar
Descartar
Related Posts Respostes Vistes Activitat
ORM Query Search Solved
orm query
Avatar
Avatar
Avatar
7
d’abr. 22
16774
Execute query when installing addon Solved
modules addons orm query
Avatar
Avatar
2
de maig 18
12273
Available Serial numbers for move lines
orm query browse fetch
Avatar
0
de març 15
6467
Odoo Performance Discussion: Slow Dashboards, Reports & Repeated Data Access
postgresql orm query odoo indexing
Avatar
0
d’abr. 26
634
How can employees easily manage corporate card receipt uploads
v18
Avatar
0
de des. 25
39