From 96c4a5bf729832f704dd86f2271d6f3531ebb4e9 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 17 Oct 2016 10:34:18 -0400 Subject: [PATCH] remove holds based on fulfillment library --- remove_ou_data/03_remove_holds.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/remove_ou_data/03_remove_holds.sql b/remove_ou_data/03_remove_holds.sql index 76dfa14..433f3ef 100644 --- a/remove_ou_data/03_remove_holds.sql +++ b/remove_ou_data/03_remove_holds.sql @@ -41,6 +41,9 @@ DELETE FROM action.aged_hold_request WHERE request_lib IN DELETE FROM action.hold_request WHERE requestor IN (SELECT id FROM actor.usr WHERE home_ou IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); +DELETE FROM action.hold_request WHERE fulfillment_lib IN +(SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); + COMMIT; ALTER TABLE action.hold_request ENABLE TRIGGER action_hold_request_aging_tgr; -- 1.7.2.5