X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;fp=mig-xml%2Fevergreen_staged_report.xml;h=29283e6729721ac464dc35d13e4b7e4d70a3ee2f;hp=81f3cc170265406c444dae644277a44c9a685666;hb=b4193f22989c3974cb627df4da4bb603b1b061e0;hpb=01a59bd308f78acbe974fafe3030148d2f5c95fb
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));