Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
All Posts Люди Значки
Теги (View all)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
9 Ответы
36748 Представления
Аватар
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

Аватар
Отменить
Аватар
Zbik
Лучший ответ

Try this:

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


Аватар
Отменить
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
Автор

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

Аватар
Shameem Babu
Лучший ответ


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





Аватар
Отменить
CARLOS ALBERTO GARCIA BRIZUELA

Works great thanks, and easy to understand!

Аватар
Muhammad Awais
Лучший ответ

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

Аватар
Отменить
Аватар
Seppe De Roeck
Автор Лучший ответ

Worked wonderfully well, big thanks for quick reply !!

Аватар
Отменить
Аватар
Khalid Hazam
Лучший ответ

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]}
Аватар
Отменить
Аватар
Ievgen Synchyshyn
Лучший ответ

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]"/>
Аватар
Отменить