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

Alle Beiträge Personen Abzeichen

Stichwörter (Alle anzeigen)

odoo accounting v14 pos v15

Über dieses Forum

Hilfe

How to add Current Week filter

search_view

2 Antworten

951 Ansichten

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.

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!

Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!

Registrieren

Verknüpfte Beiträge	Antworten	Ansichten
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 März 25	8194
search one2many different field. Gelöst purchase_order search_view	2 Jan. 22	2228
search filter with more than one condition search_view odoo10	1 Feb. 21	5472
Search view extension problem Gelöst search_view odoo12	1 Dez. 19	3373

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!