projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(from parent 1:
4403457
)
added check to make sure holds were fulfilled when deleting by fulfillment library
author
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 17 Oct 2016 18:47:19 +0000 (14:47 -0400)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 17 Oct 2016 18:47:19 +0000 (14:47 -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
de1aac1
..
80afcf7
100644
(file)
--- 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;