Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
9 Odpowiedzi
36750 Widoki
Awatar
Seppe De Roeck

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

Awatar
Odrzuć
Awatar
Zbik
Najlepsza odpowiedź

Try this:

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


Awatar
Odrzuć
Axel Mendoza

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

Seppe De Roeck
Autor

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

Awatar
Shameem Babu
Najlepsza odpowiedź


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]"/>





Awatar
Odrzuć
CARLOS ALBERTO GARCIA BRIZUELA

Works great thanks, and easy to understand!

Awatar
Muhammad Awais
Najlepsza odpowiedź

if you want to get rid of False error

It should also work

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

Another solution:
use <t t-field="o.your_field"/>

Awatar
Odrzuć
Awatar
Seppe De Roeck
Autor Najlepsza odpowiedź

Worked wonderfully well, big thanks for quick reply !!

Awatar
Odrzuć
Awatar
Khalid Hazam
Najlepsza odpowiedź

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]}
Awatar
Odrzuć
Awatar
Ievgen Synchyshyn
Najlepsza odpowiedź

Thanks, Zbik, I used your suggestion in my case for each order line to html orders report as a list, and it's working in v.11:

<t t-esc="dict(doc.order_id.fields_get(allfields=['my_field_in_SO'])['my_field_in_SO']['selection'])[doc.order_id.my_field_in_SO]"/>
Awatar
Odrzuć