From 16a82253bc9014f64bd07e05077ee2b4b0b7f810 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Wed, 8 Aug 2018 13:36:27 -0400
Subject: [PATCH] adding precats to assets 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 491965c..b6f58f0 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -315,6 +315,15 @@
     </report>
 
     <report>
+        <name>asset_precat</name>
+        <report_title>Precats (AKA Copies Without Bibs)</report_title>
+        <tag>assets</tag>
+        <iteration>0</iteration>
+        <heading>Copy Count.Migating</heading>
+        <query>SELECT COUNT(ac.id), ac.x_migrate::TEXT FROM asset_copy_legacy ac WHERE ac.x_bre_id = -1 GROUP BY 2</query>
+    </report>
+
+    <report>
         <name>asset_circ_mod_copies_count</name>
         <report_title>Copies by Circulation Modifier</report_title>
         <tag>assets</tag>
-- 
1.7.2.5