Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

[Qweb Report For Perticular date]Add filter to Qweb report.

odoo12.0 Niyas OCA Cybrosys

1 الرد

5565 أدوات العرض

Soudhankhi Dalai

Hi all,

I want to add a date filter to a Qweb report.My requirement is to mail a report which only has "create_date" is equal to "yesterday".

My code looks like the below.

<?xml version="1.0"?>
<t t-name="crm.lead.future_report_walkin">
            <t t-call="web.html_container">

                  <t t-call="web.external_layout">

                        <table class="table table-bordered">

                          
                          <div class="row bg-primary">
                            <div class="col-2" style="border: 1px solid black;">Name</div>
                            <div class="col-2" style="border: 1px solid black;">Mobile</div>
                            <div class="col-2" style="border: 1px solid black;">Counselor</div>
                            <div class="col-2" style="border: 1px solid black;">Course</div>
                            
                            <div class="col-2" style="border: 1px solid black;">City</div>
                            <div class="col-2" style="border: 1px solid black;">WalkIn Date</div>
                          </div>

                          <t t-foreach="docs" t-as="o">
                            <div class="row">
                              
                              <div class="col-2" style="border: 1px solid black;">
                              <t t-esc="o.name"></t>
                              </div>
                              <div class="col-2" style="border: 1px solid black;">
                              <t t-esc="o.mobile"></t>
                              </div>
                              <div class="col-2" style="border: 1px solid black;">
                              <t t-esc="o.user_id.name"></t>
                              </div>

                              
                              <div class="col-2" style="border: 1px solid black;">
                              <t t-esc="o.city"></t>
                              </div>

                            </div>
                          </t>
                        </table>

                    </t>
            </t>
        </t>

Now this is downloding all data present in list view.

If it is not possible by adding filter to Qweb then what will its procedure to download specific date wise data.Please answer.

CandidRoot Solutions Private Limited

Hello Soudhankhi Dalai,

There are multiple ways to do this filter.

Options 1: filter docs

x.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d'))" t-as="doc">

Option 2: add t-if condition to compare record date in div tag

doc.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d')">

Option 3: you can call method from xml to python like doc.your_method_name to filter records

CandidRoot Solutions Private Limited

There are multiple ways to do this filter.

Options 1: filter docs

Option 2: add t-if condition to compare record date in div tag

Option 3: you can call method from xml to python like doc.your_method_name to filter records

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
How to loadXML in Odoo js 16 تم الحل Niyas Cybrosys	2 أغسطس 23	3799
How should a commission be divided between two people? commission Niyas Cybrosys	2 فبراير 24	81
add search panel in graph and pivot view in odoo 16 Niyas Cybrosys odoo16features	1 ديسمبر 23	1982
how to hide delete button in form view and tree view with a condition in odoo 16 odoo Niyas Cybrosys	0 سبتمبر 23	2831
Report in email body odoo Niyas Cybrosys	0 أغسطس 23	1897

لقد تم الإبلاغ عن هذا السؤال

Options 1: filter docs

x.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d'))" t-as="doc">Option 2: add t-if condition to compare record date in div tag

doc.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d')">Option 3: you can call method from xml to python like doc.your_method_name to filter records

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

x.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d'))" t-as="doc">

Option 2: add t-if condition to compare record date in div tag

doc.create_date.strftime('%Y-%m-%d') == (datetime.date.today() - relativedelta(days=1)).strftime('%Y-%m-%d')">

Option 3: you can call method from xml to python like doc.your_method_name to filter records