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 ...
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
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
Ex:
self.env['sale.order']._fields['state'].selection
Perhaps this approach will be too slow for large requests.
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.
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.
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati
Check this Odoo Customization Tips: https://github.com/sehrishnaz/learnopenerp/wiki