From 128b0996911b521781b39f26b17b558f44ce2388 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 15 Jul 2019 10:34:56 -0400 Subject: [PATCH] JBAS-2314 Patron expire date extension repair Extend accounts whose last activity occurred after midnight the previous day. This fixes an issue where accounts whose latest activity is always yesterday (e.g. scko logins) were never updated. Signed-off-by: Bill Erickson --- KCLS/utility-scripts/patron_activity/patron_activity.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/KCLS/utility-scripts/patron_activity/patron_activity.sql b/KCLS/utility-scripts/patron_activity/patron_activity.sql index 28757abd4b..d54d816e3b 100644 --- a/KCLS/utility-scripts/patron_activity/patron_activity.sql +++ b/KCLS/utility-scripts/patron_activity/patron_activity.sql @@ -6,7 +6,8 @@ UPDATE actor.usr usr FROM permission.grp_tree grp where grp.id = usr.profile and usr.id IN ( SELECT DISTINCT(usr) FROM actor.usr_activity - WHERE event_time BETWEEN current_date - 2 AND current_date - 1 + -- Events that occurred after midnight yesterday. + WHERE event_time > current_date - 1 AND actor.usr_activity.usr IS NOT NULL ) AND NOT barred -- 2.11.0