Non-functional filter for the current week

Question

I need a filter that will filter production orders only with date_planned_start in the current week.

Can you please advise.

Nigist Mamo · Accepted Answer

please try to use this filter command in your search view
< filter  string = "This Week"  name = " date_planned_start "  domain = "[        (' date_planned_start ', '>=', (datetime.datetime.combine(context_today() + relativedelta(weeks=-1,days=1,weekday=0), datetime.time(0,0,0)).to_utc()).strftime('%Y-%m-%d %H:%M:%S')),        (' date_planned_start ', ' < ', (datetime.datetime.combine(context_today() + relativedelta(days=1,weekday=0), datetime.time(0,0,0)).to_utc()).strftime('%Y-%m-%d %H:%M:%S')

Kunjan Patel · Answer

Hello Radim Soja,
I hope you are doing well
*
You can try that:* domain="[('date_planned_start','>=',(context_today() relativedelta(days=context_today().weekday())).strftime('%Y-%m-%d')),('date_planned_start','<', (context_today()+relativedelta(days=7-context_today().weekday())).strftime('%Y-%m-%d'))]"
I hope this information helps you
Thanks & Regards,
*Kunjan Patel*

Powiązane posty	Odpowiedzi	Widoki
Odoo 12 Online: How to force - and lock custom filter in contacts, disable the remove function Rozwiązane filtering	2 mar 25	7779
Add Custom Group Option filtering	0 gru 24	2863
Field management service: filter rules filtering	2 sty 24	3251
Dynamic date in filters Rozwiązane filtering	4 kwi 25	14652
Sharing Odoo links with filters applies filtering links	0 kwi 26	3553

To pytanie dostało ostrzeżenie

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