From cedef2a45db4cf9ba09fdbb7a6959014403e46f5 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 14 Jan 2020 13:31:05 -0500
Subject: [PATCH] adding missing x_migrate filter

---
 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 b8ab88b..6901c18 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -755,7 +755,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <tag>actors</tag>
         <iteration>0</iteration>
         <heading>Count of Users.Active</heading>
-        <query>SELECT COUNT(id), active::TEXT FROM m_actor_usr_legacy GROUP BY 2</query>
+        <query>SELECT COUNT(id), active::TEXT FROM m_actor_usr_legacy WHERE x_migrate = TRUE GROUP BY 2</query>
     </report>
 
     <report>
-- 
1.7.2.5