From b4193f22989c3974cb627df4da4bb603b1b061e0 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 23 Jan 2020 09:25:20 -0500 Subject: [PATCH] fixing errant line --- mig-xml/evergreen_staged_report.xml | 2 -- 1 files changed, 0 insertions(+), 2 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 81f3cc1..29283e6 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -1135,8 +1135,6 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 ID.Active.Owner.Name SELECT ed.id, ed.active::TEXT, aou.shortname, ed.name FROM action_trigger.event_definition ed - SELECT ed.id, ed.active::TEXT, aou.shortname, ed.name - FROM action_trigger.event_definition ed JOIN actor.org_unit aou ON aou.id = ed.owner WHERE ed.owner IN (SELECT DISTINCT home_ou FROM m_actor_usr) OR ed.owner IN (SELECT DISTINCT parent_ou FROM actor.org_unit WHERE id in (SELECT DISTINCT home_ou FROM m_actor_usr)); -- 1.7.2.5