From 60e088b624dcf37cb71119b31a66b61d17e36efb Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 17 Apr 2018 12:45:00 -0400
Subject: [PATCH] fixed some bugs in mig-xml staged reports looking for old bib_id_map rather than the staged table

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

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 47b2423..866a09c 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -646,7 +646,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <tag>bibs</tag>
         <iteration>1</iteration>
         <heading>Count</heading>
-        <query>SELECT COUNT(eg) FROM bib_id_map</query>
+        <query>SELECT COUNT(id) FROM biblio_record_entry</query>
     </report>
 
     <report>
@@ -655,7 +655,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <tag>bibs</tag>
         <iteration>0</iteration>
         <heading>Count</heading>
-        <query>SELECT COUNT(eg) FROM bib_id_map where eg::INTEGER NOT IN (SELECT DISTINCT record FROM asset_call_number)</query>
+        <query>SELECT COUNT(id) FROM biblio_record_entry where id NOT IN (SELECT DISTINCT record FROM asset_call_number)</query>
     </report>
 
     <report>
-- 
1.7.2.5