Odoo Help


Showing the string value of a selection field in Qweb report

Seppe De Roeck
on 10/24/15, 4:15 AM 3,358 views

Hi all,

I have a Qweb PDF report where I am fetching some custom records.  One of the fields I want to display is a SELECTION field such as for example x_approval_status with Selection definition of : [('A','Approved'),('D','Denied')].

In the Qweb query I am fetching these records and showing the field, like <t t-raw="object.x_approval_status" />.  This works, it shows the 'A' or 'D' values.

How can I show the 'Approved' or 'Denied' values ?



On 10/24/15, 6:01 AM

Try this:

<t t-esc="dict(object.fields_get(allfields=['x_approval_status'])['x_approval_status']['selection'])[object.x_approval_status]"/>

Awesome, your way is better than mine at
I upvote your answer. It's a more clean way

Axel Mendoza
on 10/24/15, 6:15 AM

Hi Zbik, do you also know how the syntax is if this were an email template ? Thanks !

Seppe De Roeck
on 8/23/16, 2:20 AM

zbik 's answer is awesome. But error will be raised if Selection field has False value.

Otherwise use this. 

<t t-set="values" t-value="dict([('A','Approved'),('D','Denied'), (False,False)])"/> 
<t t-esc="values[object.x_approval_status]"/>


<t t-esc="{False: False, 'A': 'Approved', 'D': 'Denied'}[object.x_approval_status]"/>

Seppe De Roeck
On 10/24/15, 6:08 AM

Worked wonderfully well, big thanks for quick reply !!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 10/24/15, 4:15 AM
Seen: 3358 times
Last updated: 7/2/17, 2:18 AM