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

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo 13. Don't close a wizard when Click a button Ratkaistu Odoo13.0	4 toukok. 24	14299
Permission error while user printing excel sheet report in odoo 13 Ratkaistu Odoo13.0	1 huhtik. 24	4463
One2many field edited from Transient Model cannot be made empty. Odoo13.0	0 marrask. 23	3145
Blank White Page After log in to Odoo13 Ratkaistu Odoo13.0	1 syysk. 23	3280
How can I translate Options in Selection.field? Ratkaistu Odoo13.0	2 elok. 23	6097

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!