Selection field in SQL Query

Question

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 ...

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

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

OBEH · Answer

*Ex:*
self.env['sale.order']._fields['state'].selection

Perhaps this approach will be too slow for large requests.

Jake Robinson · Answer

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.

ARUN JACOB · Answer

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 THEN END Thanks.

This question has been flagged

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