From 6ddea01a5729d7d83209d4490245c5fbde64ac80 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 16 Mar 2018 08:18:29 -0400 Subject: [PATCH 1/1] fixed bug in sql query for a dedupe report --- mig-xml/evergreen_staged_report.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 26ee65b..b246603 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -1042,7 +1042,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 Scoring and Bib Record Groups Count.Bib REcord Groups SELECT COUNT(id), 'Total Bibs Being Evaluated' FROM biblio.record_entry WHERE deleted IS FALSE AND id IN (SELECT eg::BIGINT FROM bib_id_map) - UNION ALL SELECT (COUNT(DISTINCT incoming_bib), 'Incoming Bibs With Matches Found' FROM bib_matches + UNION ALL SELECT (COUNT(DISTINCT incoming_bib)), 'Incoming Bibs With Matches Found' FROM bib_matches UNION ALL SELECT (COUNT(bre.id) - (SELECT COUNT(DISTINCT incoming_bib) FROM bib_matches)), 'Incoming Bibs With No Match' FROM biblio.record_entry bre WHERE bre.deleted IS FALSE AND bre.id IN (SELECT eg::BIGINT FROM bib_id_map) UNION ALL SELECT COUNT(DISTINCT incoming_bib), 'Incoming Bibs Being Merged into Incumbent' FROM bib_matches WHERE incumbent_bib_score >= incoming_bib_score -- 1.7.2.5