X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=878fac4df32cfacf3967547507d7d475ffdc8282;hp=92c723684a30c12a08904ab6022f6492c44c44cb;hb=81523fae6fffd7b5cdb9e83356c44959ec3799cd;hpb=73d5fd17efb5b98b42e37325cbcfafe5de3190ca
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 92c7236..878fac4 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -285,6 +285,34 @@
SELECT COUNT(ahr.id), ahr.selection_depth FROM action.hold_request ahr WHERE ahr.id IN (SELECT id FROM action_hold_request) AND ahr.cancel_time IS NULL AND ahr.capture_time IS NULL AND ahr.fulfillment_time IS NULL GROUP BY 2 ORDER BY 2
+
+
+ duplicate_title_matching_holds
+ holds
+ 0
+ Holds by Title Matchs
+ Count.Number of Matches
+ SELECT COUNT(*), x_title_matches FROM action_hold_request_legacy WHERE TO_DATE(l_expire_date,'MM/DD/YYYY') > NOW() GROUP BY 2 ORDER BY 2
+
+
+
+ duplicate_title_matching_holds_w_zero
+ holds
+ 0
+ Sample of Holds with No Matches
+ Borrower Barcode.Title.Request Date
+ 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
+
+
+
+ duplicate_title_matching_holds_w_greater_than_1
+ holds
+ 0
+ Sample of Holds with More Than One Title Match
+ Borrower Barcode.Title.Request Date
+ 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
+
+