From: Rogan Hamby <rhamby@esilibrary.com>
Date: Wed, 8 Aug 2018 17:45:45 +0000 (-0400)
Subject: cleaning up bib report and adding source column to it
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=5f91fb205ffb7dc220bd1b2812cd4becd1d86cba

cleaning up bib report and adding source column to it
---

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index b6f58f0..ca0d47c 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -655,21 +655,12 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <report_title>Extracted Bibliographic Records</report_title>
         <tag>bibs</tag>
         <iteration>0</iteration>
-        <heading>Count.Deleted.Migrated</heading>
-        <query>SELECT COUNT(bre.id), bre.deleted::TEXT, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3</query>
+        <heading>Count.Sourcee.Migrated</heading>
+        <query>SELECT COUNT(bre.id), bre.x_source, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3</query>
         <note>False means the records are not deleted.</note>
     </report>
 
     <report>
-        <name>bibs</name>
-        <report_title>Extracted Bibliographic Records</report_title>
-        <tag>bibs</tag>
-        <iteration>1</iteration>
-        <heading>Count</heading>
-        <query>SELECT COUNT(id) FROM biblio_record_entry_stage WHERE x_migrate = TRUE</query>
-    </report>
-
-    <report>
         <name>bibswovolumes</name>
         <report_title>Bibliographic Records Without Volumes</report_title>
         <tag>bibs</tag>