From 6aa25bdacac4eab43e1993a55704c94b1fcf311a Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 26 Mar 2018 14:47:42 -0400 Subject: [PATCH] fix outdated query --- remove_ou_data/18_delete_usrs_stage_3.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) 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 --- 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 -- 1.7.2.5