From 3e12dd990b438752403a9e21bdfbd47deb95ca17 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 17 Oct 2016 11:03:02 -0400 Subject: [PATCH 1/1] add deleting holds by request lib --- remove_ou_data/03_remove_holds.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/remove_ou_data/03_remove_holds.sql b/remove_ou_data/03_remove_holds.sql index 433f3ef..de1aac1 100644 --- a/remove_ou_data/03_remove_holds.sql +++ b/remove_ou_data/03_remove_holds.sql @@ -30,6 +30,8 @@ DELETE FROM action.hold_request WHERE current_shelf_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); DELETE FROM action.hold_request WHERE pickup_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); +DELETE FROM action.hold_request WHERE request_lib IN +(SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); DELETE FROM action.aged_hold_request WHERE pickup_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); -- 1.7.2.5