How can we fetch data field directly from DB in odoo 13 by language we want?

Question

I define Translatable field in Odoo

class ProductCategory ( models . Model ):
_inherit =  "product.category"
name = fields.Char( translate = True )
! "English / deutsch"
now I want to read the data from this field in QWEB or Python file by English or Deutsch!
if I use below form, I can access to user_lang:
env['product.category'].browse(5).name
can you help me?!

env['product.category'].browse(5).name(en)

env['product.category'].browse(5).name(de)

Hamed · Answer

Thanks, Sudhir
But I don't know why it is not true on "product.category" model.
env['product.category'].with_context(lang='de_DE').browse(5).name
>> 40.100 Mobilfunkdatenkarten T-Mobile
env['product.category'].with_context(lang='en_US').browse(5).name
>> 40.100 Mobilfunkdatenkarten T-Mobile
But in fact they are different!

Sudhir Arya (ERP Harbor Consulting Services) · Answer

You need to pass the lang code in the context to have the content in translation.
*Ex:*
env['product.product'].with_context(*lang='nl_BE'*).browse(5).name

Related Posts	Replies	Views
Odoo 13. Don't close a wizard when Click a button Solved Odoo13.0	4 May 24	10064
Permission error while user printing excel sheet report in odoo 13 Solved Odoo13.0	1 Apr 24	1561
One2many field edited from Transient Model cannot be made empty. Odoo13.0	0 Nov 23	523
Blank White Page After log in to Odoo13 Solved Odoo13.0	1 Sep 23	561
How can I translate Options in Selection.field? Solved Odoo13.0	2 Aug 23	2421

This question has been flagged

Enjoying the discussion? Don't just read, join in!