From 36306b1fde86ccec0014b545167dcc61862a4faa Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 23 Jan 2020 09:21:26 -0500 Subject: [PATCH] changes to notification reports --- mig-xml/evergreen_staged_report.xml | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 38c2ef2..8978099 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -1134,7 +1134,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Action Triggers Setup for Notices ID.Active.Owner.Name SELECT ed.id, ed.active, aou.shortname, ed.name - FROM m_action_trigger.event_definition ed + 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)); @@ -1148,9 +1148,9 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Count of Notices Run with State Count of Notices.State.ID.Owner.Name SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, ed.name - FROM m_action_trigger.event_definition ed + FROM action_trigger.event_definition ed JOIN actor.org_unit aou ON aou.id = ed.owner - JOIN m_action_trigger.event ate ON ate.event_def = ed.id + JOIN action_trigger.event ate ON ate.event_def = ed.id 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)) GROUP BY 2,3,4; -- 1.7.2.5