From 81523fae6fffd7b5cdb9e83356c44959ec3799cd Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 6 Aug 2019 09:55:40 -0400 Subject: [PATCH] multiple title hold report matches reports --- mig-xml/evergreen_staged_report.xml | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 insertions(+), 0 deletions(-) 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 + + -- 1.7.2.5