How to print the string value of a selection field instead of its key

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Project
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How to print the string value of a selection field instead of its key

field print selection string

2 Vastaukset

9811 Näkymät

babis peroukas

Hello

I have two more questions (I dont want to spam post questions):

1) How can can I recieve the string value of a selection field ( [('1','Our base'), ('2','Client's base')] )? In this case I want to print for example "Our base". In my report I use [ o.x_loadbase ]] (the name of the field) but it prints just the key (1) intead of the value (Our base). Even if I send it to another model (its in the sale.order and i send it to account.invoice) it shows the key value.

2) Is there any way to assign a journal and sequence to the cancelled invoices?

Thanks

David Warner

Add these lines in your RML file where you are trying to fetch Value of your field (i.e.selection field).

<para style="terp_header">Our Base[[ ((o.x_loadbase == '1') or removeParentNode('para')) and '' ]]</para>

<para style="terp_header">Client's Base[[ ((o.x_loadbase == '2') or removeParentNode('para')) and '' ]]</para>

And also add one more line in Your RML file in header

<paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="7.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>

It"ll, Surely Solve your problem

babis peroukas

Tekijä

Hello and thanks for the answer, but isnt there any other way so I dont do this for every selection field I create? Also I want those values to pass from a model to another (from sale.order to account.invoice) so I ve put the fields in sale.order vals, but they are just passed with their keys and not with theit strings. In this case the printed field is not selection type... its char. Thanks :)

David Warner

May I know all your selection values are constant throughout?

riess82

Easier and more flexible is [ o.x_loadbase == '1' and 'Our base']

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

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
field visible as text for manager and dropdown for employee field selection	0 maalisk. 15	3421
get Id in field selection field selection	1 maalisk. 15	8366
Can you show the string of a selection field in Report Editor, or write it to another field? field openoffice selection	1 maalisk. 15	7888
Create Menu dialog plus define selection items xml field selection	1 maalisk. 15	3912
Selcetion Fields With Many2One RelationShip ? field relationship selection	1 maalisk. 15	3879

Tämä kysymys on merkitty

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