From 379ffe1304540fcb7ee28400048c6cee9411218f Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Thu, 23 Jan 2020 09:19:23 -0500
Subject: [PATCH] fixing boolean to be more readable in report

---
 mig-xml/evergreen_staged_report.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 38c2ef2..b89183b 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -1133,7 +1133,7 @@ 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 m_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)
-- 
1.7.2.5