No more "EndTime"?
Posted: Sun May 16, 2021 9:49 am
I have a filter that deletes motion-detection's during night. Filter stopped working after upgrade to 1.36.
What should I use instead of EndTime?
Log:
Can't execute filter 'SELECT E.*, unix_timestamp(E.StartDateTime) as Time FROM Events as E WHERE ( E.Archived = 0 and E.Cause = 'Motion' and ( extract( hour_second from E.StartDateTime ) > extract( hour_second from '2021-05-16 20:00:00' ) or E.EndTime < extract( hour_second from '2021-05-16 05:30:00' ) ) ) ORDER BY E.Id ASC LIMIT 0,100', ignoring: Unknown column 'E.EndTime' in 'where clause'
What should I use instead of EndTime?
Log:
Can't execute filter 'SELECT E.*, unix_timestamp(E.StartDateTime) as Time FROM Events as E WHERE ( E.Archived = 0 and E.Cause = 'Motion' and ( extract( hour_second from E.StartDateTime ) > extract( hour_second from '2021-05-16 20:00:00' ) or E.EndTime < extract( hour_second from '2021-05-16 05:30:00' ) ) ) ORDER BY E.Id ASC LIMIT 0,100', ignoring: Unknown column 'E.EndTime' in 'where clause'