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=8978099ddc82401b9b28e6024e546ca9156fb07f;hp=38c2ef2c6ffce7323827c15ae2e97ab609a4a55b;hb=36306b1fde86ccec0014b545167dcc61862a4faa;hpb=e17591dbeecd9d2edec570420a726706ec2a94ce
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;