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

Alle bidrag Personer Emblemer

Tags (Vis alle)

odoo accounting v14 pos v15

Om dette forum

Hjælp

How to add Current Week filter

search_view

2 Besvarelser

1000 Visninger

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.

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!

Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!

Tilmeld dig

Relaterede indlæg	Besvarelser	Visninger
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	8235
search one2many different field. Løst purchase_order search_view	2 jan. 22	2236
search filter with more than one condition search_view odoo10	1 feb. 21	5486
Search view extension problem Løst search_view odoo12	1 dec. 19	3382

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!