Hello, I am trying to add a filter for current week. I tried this It just filters by the current month anyway.

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

How to add Current Week filter

search_view

2 Replies

940 Tampilan

Tony

Hello,

I am trying to add a filter for current week.

I tried this

<filter string="Current Week"name="filter_current_week"domain="[('date', '>=', (context_today() - datetime.timedelta(days=context_today().weekday())).strftime('%Y-%m-%d')), ('date', '<=', (context_today() + datetime.timedelta(days=6 - context_today().weekday())).strftime('%Y-%m-%d'))]"/>

It just filters by the current month anyway.

Kunjan Patel

Hello Tony,
I hope you are doing well

The issue is likely % signs need escaping in XML. Use %% instead:

<filter string="Current Week" name="filter_current_week"                                                                                                                                    
      domain="[   
          ('date', '>=', (context_today() - datetime.timedelta(days=context_today().weekday())).strftime('%%Y-%%m-%%d')),                                                                     
          ('date', '&lt;=', (context_today() + datetime.timedelta(days=6 - context_today().weekday())).strftime('%%Y-%%m-%%d'))
      ]"/>

Without escaping, XML misinterprets the % characters, causing the domain to silently fail and fall back to month-level filtering.

I hope this information helps you

Thanks & Regards,
Kunjan Patel

Cybrosys Techno Solutions Pvt.Ltd

Hi,

Please refer to the code:

<filter name="this_week" string="This Week" domain="[('create_date', '>=', (context_today() - datetime.timedelta(days=context_today().weekday())).strftime('%Y-%m-%d'))]"/>

Hope it helps.

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
Filter In Search Clears Everything - Not Just Desired Items search_view	0 Feb 24	29
How to disable “Add custom filter” and “Add custom group” options in odoo? views search_view	2 Mar 25	8188
search one2many different field. Diselesaikan purchase_order search_view	2 Jan 22	2223
search filter with more than one condition search_view odoo10	1 Feb 21	5438
Search view extension problem Diselesaikan search_view odoo12	1 Des 19	3357

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!