跳至内容
此问题已终结
filterweek
4 回复
13089 查看
形象
avasen

hello,

i wanted to know how to filter by reord for the current week from monday that means if today is monday i want all the record from today to next monday if we are sunday i want all the record from last monday to next monday no matter which day we are i want from this week monday to the next

thanks a lot

形象
丢弃
形象
Darshan Patel
最佳答案

Hello, Current Week Filter could be achieved with the following code :

<filter string="Current Week" name="current_week"
 domain="[('helpdesk_ticket_create_date', '&lt;=', ((context_today()+relativedelta(weeks=0, weekday=-1)).strftime('%Y-%m-%d'))), 

('helpdesk_ticket_create_date', '&gt;=', ((context_today()-relativedelta(weeks=1, weekday=0)).strftime('%Y-%m-%d')))]"/>

So it doesn't matter which day is today, this code filters on weekly basis only.


Regards,

Darshan!


形象
丢弃
形象
Burhan Vakharia
最佳答案

Hello brami,


You can create a filter like this,

<filter string="Current Week" name="Current Week" domain="[('date','&lt;',(context_today()+relativedelta(days=7)).strftime('%Y-%m-%d 23:59:59')), ('date','&gt;=',context_today().strftime('%Y-%m-%d 00:00:00'))]"/>


This will give you the filter you require for the current week. For eg, if today is Monday then records till next Monday.


Hope this helps,

Thank You.

形象
丢弃
形象
Alexandre Dufresne
最佳答案

Burhan Vakharia's solution doesn't seem to work.

It returns records from [today] to [today + 7 days].

That's not what avasen was looking for. If today is saturday, he wants to see record from last monday to next monday, not records from saturday (today) to next saturday.

Thank you for the help, though!

形象
丢弃
形象
Swagat Parida
最佳答案 
Hello,
The perfect solution was in the base(addons/im_livechat/views).

<filter string="This Week" name="creation_date_filter" domain="[
('create_date', '>=', (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')),
('create_date', '/>


形象
丢弃
相关帖文 回复 查看 活动
Differentiating subscription invoices from one-shot services 已解决
filter
形象
形象
形象
3
9月 25
238
How to filter contact those parent are in archive stage 已解决
filter
形象
形象
1
9月 25
589
Simultaneous search criteria across companies and persons
filter
形象
形象
1
8月 25
263
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers
filter
形象
0
7月 25
1024
Filters in multiple companies 已解决
filter
形象
形象
1
5月 25
1709