Sign in
Try it free

Odoo Help
Help
Ask a Question
2

Showing the string value of a selection field in Qweb report

By
Seppe De Roeck
on 10/24/15, 4:15 AM • 4,521 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 ?

tx

Seppe

6

Zbik

--Zbik--
6750
| 6 5 7
Lodz, Poland
--Zbik--


Zbik
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
https://www.odoo.com/es_ES/forum/help-1/question/how-to-define-a-custom-methods-functions-to-be-used-in-a-qweb-report-how-to-define-and-use-a-report-parser-92244
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
1

Shameem Babu @ iWesabe

--Shameem Babu @ iWesabe--
GLOBAL CREATIVE CONCEPTS TECH CO LTD
http://www.iwesabe.com
1257
| 6 3 6
KHOBAR, Saudi Arabia
--Shameem Babu @ iWesabe--

  

 iWesabe - ODOO ERP IMPLEMENTATION & CUSTOMIZATION SAUDI ARABIA.



For Queries :  shameem@iwesabe.com

Activities     :    Youtube

                           Stackoverflow 

Experience: 

           iWesabe                                  ◉

           Axon Communications        ❍

           Cybrosys Technologies        ❍
Shameem Babu @ iWesabe
On 7/2/17, 2:18 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]"/>

Or

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





0
Khalid Hazam
On 2/15/18, 10:26 AM

Just wanted to chime in and say that zbik's answer also works in email templates. This is an example that can be used in contracts reminder:



${dict(object.fields_get(allfields=['recurring_rule_type'])['recurring_rule_type']['selection'])[object.recurring_rule_type]}
0
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.

Register

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)

Stats

Asked: 10/24/15, 4:15 AM
Seen: 4521 times
Last updated: 2/15/18, 10:26 AM