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

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Sobre este foro

Ayuda

How to add Current Week filter

search_view

2 Respuestas

948 Vistas

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.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse

Publicaciones relacionadas	Respuestas	Vistas
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	8189
search one2many different field. Resuelto purchase_order search_view	2 ene 22	2226
search filter with more than one condition search_view odoo10	1 feb 21	5470
Search view extension problem Resuelto search_view odoo12	1 dic 19	3364

Esta pregunta ha sido marcada

¿Le interesa esta conversación? ¡Participe en ella!