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=81f3cc170265406c444dae644277a44c9a685666;hp=8978099ddc82401b9b28e6024e546ca9156fb07f;hb=01a59bd308f78acbe974fafe3030148d2f5c95fb;hpb=36306b1fde86ccec0014b545167dcc61862a4faa

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 8978099..81f3cc1 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -1133,7 +1133,9 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <iteration>0</iteration>
         <report_title>Action Triggers Setup for Notices</report_title>
         <heading>ID.Active.Owner.Name</heading>
-        <query>SELECT ed.id, ed.active, aou.shortname, ed.name
+        <query>SELECT ed.id, ed.active::TEXT, aou.shortname, ed.name
+            FROM action_trigger.event_definition ed 
+        <query>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)