From 220c52587cae597d5ac513f122342b1e703a099b Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 17 Oct 2016 14:47:19 -0400 Subject: [PATCH 1/1] added check to make sure holds were fulfilled when deleting by fulfillment library --- remove_ou_data/03_remove_holds.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/remove_ou_data/03_remove_holds.sql b/remove_ou_data/03_remove_holds.sql index de1aac1..80afcf7 100644 --- a/remove_ou_data/03_remove_holds.sql +++ b/remove_ou_data/03_remove_holds.sql @@ -43,7 +43,7 @@ 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 +DELETE FROM action.hold_request WHERE fulfillment_time IS NOT NULL AND fulfillment_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); COMMIT; -- 1.7.2.5