Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
4 Risposte
5919 Visualizzazioni

Hi Guys,
I need to get the value of the res.partner model using SQL Query.
Most of the values ​​getting correctly.
The issue is with the selection field. It returns the internal string of the selection field.
I need the string showing in the UI.
How can I get the value of the field selection in Query?

Anyone, please help ...

Avatar
Abbandona
Risposta migliore

You cannot get that display value directly but either you can use if conditions to compare the keys of the selection and hardcode the display value or you can fetch the selection value (key, value) from the field.

Ex:

self.env['sale.order']._fields['state'].selection


Avatar
Abbandona
Risposta migliore

Ex:

self.env['sale.order']._fields['state'].selection


Perhaps this approach will be too slow for large requests.

Avatar
Abbandona
Risposta migliore

The selection text is stored in the ir.model.fields.selection model. If doing it purely through SQL you will need to do a join on this table, matching the field_id and value column and reading the name column.

Avatar
Abbandona
Autore Risposta migliore

Hi Sudhir Arya,

​self.env['sale.order']._fields['state'].selection


this is API method, I need query.

Anyway, As you said I can use like;
 CASE WHEN <Condition> THEN <Value> END 

Thanks.

Avatar
Abbandona