projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(from parent 1:
099b914
)
remove holds based on fulfillment library
author
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 17 Oct 2016 14:34:18 +0000 (10:34 -0400)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 17 Oct 2016 14:34:18 +0000 (10:34 -0400)
remove_ou_data/03_remove_holds.sql
patch
|
blob
|
history
diff --git
a/remove_ou_data/03_remove_holds.sql
b/remove_ou_data/03_remove_holds.sql
index
76dfa14
..
433f3ef
100644
(file)
--- 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;