<tag>bibs</tag>
<iteration>1</iteration>
<heading>Count</heading>
- <query>SELECT COUNT(eg) FROM bib_id_map</query>
+ <query>SELECT COUNT(id) FROM biblio_record_entry_stage WHERE x_migrate = TRUE</query>
</report>
<report>
<tag>bibs</tag>
<iteration>0</iteration>
<heading>Count</heading>
- <query>SELECT COUNT(eg) FROM bib_id_map where eg::INTEGER NOT IN (SELECT DISTINCT record FROM asset_call_number)</query>
+ <query>SELECT COUNT(id) FROM biblio_record_entry where id NOT IN (SELECT DISTINCT record FROM asset_call_number)</query>
</report>
<report>
<!-- DEDUPE REPORTS -->
+ <asset>
+ <name>dedupe_explain</name>
+ <tag>dedupe</tag>
+ <file>dedupe_process.asciidoc</file>
+ </asset>
+
<report>
- <name>dedupe_format_count</name>
+ <name>dedupe_bib_groups</name>
<tag>dedupe</tag>
<iteration>0</iteration>
- <report_title>Count of Items Matching By Format</report_title>
- <heading>Count.Format(s)</heading>
- <query>SELECT COUNT(id), search_formats FROM bib_matches GROUP BY 2 ORDER BY 2;</query>
+ <report_title>Scoring and Bib Record Groups</report_title>
+ <heading>Count.Bib Record Groups</heading>
+ <query>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(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
+ UNION ALL SELECT COUNT(id), 'Incumbent Bibs With Higher Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score > incoming_bib_score
+ UNION ALL SELECT COUNT(id), 'Incumbent Bibs With Equal Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score = incoming_bib_score
+ UNION ALL SELECT COUNT(id), 'Incumbent Bibs With Lower Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score < incoming_bib_score
+ ;</query>
</report>
-
+
<report>
- <name>dedupe_scores</name>
+ <name>dedupe_format_count</name>
<tag>dedupe</tag>
<iteration>0</iteration>
- <report_title>Scoring Values in Matches</report_title>
- <heading>Count.Scoring Information</heading>
- <query>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
- ;</query>
+ <report_title>Count of Items Matching By Format</report_title>
+ <heading>Count.Format(s)</heading>
+ <query>SELECT COUNT(id), search_formats FROM bib_matches GROUP BY 2 ORDER BY 2;</query>
</report>
<report>