Skip to Content
This question has been flagged
ormqueryv18
2 Replies
695 डेटा देखने का तरीका
अवतार
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')

अवतार
खारिज करें
अवतार
SSSE/SIG, Luca Palo
लेखक Best Answer
Thank you 
Ray Carnes (ray)

It works!

अवतार
खारिज करें
अवतार
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)


अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
ORM Query Search Solved
orm query
अवतार
अवतार
अवतार
7
अप्रैल 22
16935
Execute query when installing addon Solved
modules addons orm query
अवतार
अवतार
2
मई 18
12384
Available Serial numbers for move lines
orm query browse fetch
अवतार
0
मार्च 15
6604
Odoo Performance Discussion: Slow Dashboards, Reports & Repeated Data Access
postgresql orm query odoo indexing
अवतार
0
अप्रैल 26
759
How can employees easily manage corporate card receipt uploads
v18
अवतार
0
दिस॰ 25
39