X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=b246603d86e7d89cf60dc2d988f31c3e87759571;hp=26ee65bbeee596e3f391866663acdc72a5c1e2ea;hb=6ddea01a5729d7d83209d4490245c5fbde64ac80;hpb=5b9d7295b87aadec1479c1d4e8b39ac6f15675c1 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