From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 17 Apr 2018 16:45:00 +0000 (-0400)
Subject: fixed some bugs in mig-xml staged reports looking for old bib_id_map rather than... 
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=60e088b624dcf37cb71119b31a66b61d17e36efb;hp=ea3559a4f7ac5fefcc0e64b1e610b26004d75d9f

fixed some bugs in mig-xml staged reports looking for old bib_id_map rather than the staged table
---

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>