Skip to Content
Menu
This question has been flagged
2 Replies
4106 Rodiniai

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!

Portretas
Atmesti
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

Portretas
Atmesti
Autorius

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


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
rugp. 25
1598
3
liep. 25
2365
1
liep. 25
1954
0
saus. 25
1438
1
gruod. 24
1861