From 11bd006e95932efc3a9210bbdf53d72e0103c9b7 Mon Sep 17 00:00:00 2001 From: Bradley Bonner Date: Fri, 26 Jun 2015 11:49:12 -0700 Subject: [PATCH] add a patron type exclusion to patron expiration extenstion job. ... (for new recip group 93, One Year - Limit Holds) Bradley Bonner - KCLS --- KCLS/utility-scripts/patron_activity/patron_activity.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/KCLS/utility-scripts/patron_activity/patron_activity.sql b/KCLS/utility-scripts/patron_activity/patron_activity.sql index 7f477097fc..f301c46fe9 100644 --- a/KCLS/utility-scripts/patron_activity/patron_activity.sql +++ b/KCLS/utility-scripts/patron_activity/patron_activity.sql @@ -10,6 +10,6 @@ WHERE event_time BETWEEN current_date - 2 AND current_date - 1 AND actor.usr_activity.usr IS NOT NULL ) AND NOT barred AND NOT deleted -AND profile NOT IN (31, 91, 17, 26, 23, 32, 90, 92); +AND profile NOT IN (31, 91, 17, 26, 23, 32, 90, 92, 93); COMMIT; -- 2.11.0