تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
9 الردود
37067 أدوات العرض
الصورة الرمزية
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]"/>
الصورة الرمزية
إهمال