Skip to Content
This question has been flagged
search_view
2 Respostes
937 Vistes
Avatar
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', '&gt;=', (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'))]"/>


It just filters by the current month anyway.


Avatar
Descartar
Avatar
Kunjan Patel
Best Answer
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
Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
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.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Filter In Search Clears Everything - Not Just Desired Items
search_view
Avatar
0
de febr. 24
29
How to disable “Add custom filter” and “Add custom group” options in odoo?
views search_view
Avatar
Avatar
Avatar
2
de març 25
8187
search one2many different field. Solved
purchase_order search_view
Avatar
Avatar
2
de gen. 22
2222
search filter with more than one condition
search_view odoo10
Avatar
Avatar
1
de febr. 21
5437
Search view extension problem Solved
search_view odoo12
Avatar
Avatar
1
de des. 19
3351