projects
/
migration-tools.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
fixing column data type in circ matrix map table
[migration-tools.git]
/
remove_ou_data
/
18_delete_usrs_stage_3.sql
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