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

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to add Current Week filter

search_view

2 Odpowiedzi

946 Widoki

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Filter In Search Clears Everything - Not Just Desired Items search_view	0 lut 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. Rozwiązane purchase_order search_view	2 sty 22	2224
search filter with more than one condition search_view odoo10	1 lut 21	5468
Search view extension problem Rozwiązane search_view odoo12	1 gru 19	3360

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!