projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
6fb82d8
)
fix outdated query
author
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 26 Mar 2018 18:47:42 +0000 (14:47 -0400)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Mon, 26 Mar 2018 18:47:42 +0000 (14:47 -0400)
remove_ou_data/18_delete_usrs_stage_3.sql
patch
|
blob
|
history
diff --git
a/remove_ou_data/18_delete_usrs_stage_3.sql
b/remove_ou_data/18_delete_usrs_stage_3.sql
index
09cc9d2
..
47518a4
100644
(file)
--- a/
remove_ou_data/18_delete_usrs_stage_3.sql
+++ b/
remove_ou_data/18_delete_usrs_stage_3.sql
@@
-22,8
+22,8
@@
SELECT id
FROM actor.usr WHERE home_ou IN (
SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit
- WHERE shortname IN (SELECT shortname FROM esi.ous_to_del)
-);
+ WHERE shortname = :ou_to_del
+) ;
-- find the problems and clear them up