From 56ff7ad9b5aa2f61b1eb747b53b76edbeaad56dd Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Wed, 11 Sep 2019 16:03:43 -0400
Subject: [PATCH] adding no barcode report

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

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index ca94ea9..123ccd5 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -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>
-- 
1.7.2.5