跳至內容
選單
此問題已被標幟
2 回覆
4097 瀏覽次數

Hello,

I would like to create a filter on the attendance module to show entries that checked-in after 7am (regardless of the date). I tried the following and it is not working:


filter domain="[['check_in', '>', check_in.replace(hour=7, minute=0)]]" string="Late"/>


Any idea will be appreciated. Thanks!

頭像
捨棄
最佳答案

Hi ,

<filter name="late" string="Late" domain="[('schedule_date','&gt;=', datetime.datetime.combine(context_today(), datetime.time(7,0,0))), ('schedule_date','&lt;=', datetime.datetime.combine(context_today(), datetime.time(23,59,59)))]"/>

Hope it Helps,

Kiran K

頭像
捨棄
作者

Hi Kiran,

This is almost what I wanted but not entirely correct, because it only returns the entries that are after 7am of the current date. I would like to get the late check-ins regardless of the date. I hope it make sense

最佳答案
You can use this if you want to filter Datetime field just by date:

<field name="min_date" widget="date" filter_domain="[('min_date','>=',self+' 00:00:00'),('min_date','<=',self+' 23:59:59')]"/>


頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
2
8月 25
1594
3
7月 25
2364
1
7月 25
1948
0
1月 25
1436
1
12月 24
1854