Hi everybody,

I have a field that gets a string from a SQL Queries

     v = {}
    cr.execute('select distinct name from product_desc where id = '1'')
    res = cr.fetchall()     
    v['my_field'] = res[0]

The field product_desc.name is a translate one (translate = true)

But the problem is my v['my_field'] is only in English and not in another language. If possible I would like to have my term in the language of my sale_order (the v['my_field'] is in sale.py)

Someone has an idea please?

Thanks a lot,

Selverine