From 998b86c5512c82176a40926de18fac2b38336532 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 13 Oct 2016 15:36:28 -0400 Subject: [PATCH] JBAS-1525 Delete holds history retention user settings Clear all user settings for managing holds history retention, so all applicable holds can be aged. Any new holds history retention starting with this commit will be starting fresh. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/purge-holds.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/KCLS/sql/schema/deploy/purge-holds.sql b/KCLS/sql/schema/deploy/purge-holds.sql index 1a4b25497d..3c7ed0618a 100644 --- a/KCLS/sql/schema/deploy/purge-holds.sql +++ b/KCLS/sql/schema/deploy/purge-holds.sql @@ -3,6 +3,9 @@ BEGIN; +-- Remove all holds history retention settings so all applicable +-- holds can be aged. +DELETE FROM actor.usr_setting WHERE name = 'history.hold.retention_start'; -- Start by purging really old holds. -- The age will march forward as we work through batches. -- 2.11.0