adding no barcode report

[migration-tools.git] / mig-xml / evergreen_staged_report.xml

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 643af69..123ccd5 100644 (file)
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -301,7 +301,7 @@
         <iteration>0</iteration>
         <report_title>Sample of Holds with No Matches</report_title>
         <heading>Borrower Barcode.Title.Request Date</heading>
-        <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches = 0 LIMIT 20</query>
+        <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches = 0 AND x_migrate LIMIT 20</query>
     </report>
 
       <report>
@@ -310,7 +310,7 @@
         <iteration>0</iteration>
         <report_title>Sample of Holds with More Than One Title Match</report_title>
         <heading>Borrower Barcode.Title.Request Date</heading>
-        <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 LIMIT 20</query>
+        <query>SELECT l_borrower_id, l_title, l_request_date FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() AND x_title_matches > 1 AND x_migrate LIMIT 20</query>
     </report>
 
     <!-- ASSET REPORTS -->
@@ -433,6 +433,15 @@
     </report -->
 
     <report>
+        <name>asset_no_barcode</name>
+        <report_title>Items Without Barcodes</report_title>
+        <tag>assets</tag>
+        <iteration>0</iteration>
+        <heading>Assigned Barcode</heading>
+        <query>SELECT barcode FROM asset_copy_legacy WHERE barcode ~* 'no_barocde' AND x_migrate</query>
+    </report>
+
+    <report>
         <name>asset_barcode_patterns</name>
         <report_title>Common Barcode Starting Patterns</report_title>
         <tag>assets</tag>
@@ -739,7 +748,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
                <tag>bibs</tag>
                <iteration>0</iteration>
                <heading>Count.Original Search Format.New Search Format</heading>
-               <query>SELECT COUNT(*), x_search_format, x_after_search_format FROM biblio_record_entry_legacy WHERE x_migrate AND x_after_search_format IS NOT NULL GROUP BY 2, 3 ORDER BY 3,2</query>
+               <query>SELECT COUNT(*), ARRAY_TO_STRING(x_search_format,','), ARRAY_TO_STRING(x_after_search_format,',') FROM biblio_record_entry_legacy WHERE x_migrate AND x_after_search_format IS NOT NULL GROUP BY 2, 3 ORDER BY 3,2</query>
        </report>
 
     <report>