From 55b8c745e9563245a55f799ed01e60733e91f4b8 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 12 Mar 2018 14:03:52 -0400 Subject: [PATCH] adding deduping reports to evergreen staged file --- mig-xml/evergreen_staged_report.xml | 47 ++++++++++++++++++++++++++++++++++- 1 files changed, 46 insertions(+), 1 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 3cc0c12..3dbb36b 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -1024,7 +1024,52 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 0 Migrated Serial MFHDs Number of MFHDs - SELECT COUNT(id) FROM seriarecord_entry + SELECT COUNT(id) FROM serial_record_entry + + + + + + dedupe_format_count + dedupe + 0 + Count of Items Matching By Format + Count.Format(s) + SELECT COUNT(id), search_formats FROM bib_matches GROUP BY 2 ORDER BY 2; + + + + dedupe_scores + dedupe + 0 + Scoring Values in Matches + Count.Scoring Information + SELECT COUNT(id), 'Incumbent Records With Higher Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score > incoming_bib_score + UNION ALL SELECT COUNT(id), 'Incumbent Records With Equal Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score = incoming_bib_score + UNION ALL SELECT COUNT(id), 'Incumbent Records With Lower Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score < incoming_bib_score + ; + + + + dedupe_score_ranges + dedupe + 0 + Count of Items Matching By Format + Lowest Record Score.Largest Record Score.Record Set + SELECT MIN(incumbent_bib_score), MAX(incumbent_bib_score), 'Incumbent Records' FROM bib_matches + UNION ALL SELECT MIN(incoming_bib_score), MAX(incoming_bib_score), 'Incoming Records' FROM bib_matches ; + + + + + + dedupe_sample_set + dedupe + 0 + Sample of 20 Matching Dedupe Record Sets + Bib Being Merged Into.Bib Being Merged + SELECT incumbent_bib, incoming_bib FROM bib_matches WHERE incumbent_bib_score >= incoming_bib_score LIMIT 20 ; + -- 1.7.2.5