From df95d36e6cd8571b68ca7ed09c1d7d62c0e4d972 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 10 Sep 2019 12:11:46 -0400
Subject: [PATCH] adding x_migrate requirement to non-matching holds reports

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

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 609e5c3..ca94ea9 100644
--- 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 -->
-- 
1.7.2.5