Skip to Content
Menu
This question has been flagged
2 Replies
3364 Views

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!

Avatar
Discard
Best Answer

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

Avatar
Discard
Author

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

Best Answer
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')]"/>


Avatar
Discard
Related Posts Replies Views Activity
1
Dec 24
53
1
Nov 24
169
3
Sep 24
254
1
Sep 23
3892
1
Jun 23
773