X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;fp=mig-xml%2Fevergreen_staged_report.xml;h=a600948c7d037be68ccc814b1679c63e8af36fe9;hp=2e973f604004d69117cbb960ebf43d5d3bd9b971;hb=96f1c7dc8276e6ea0a31549041eb056182003cbd;hpb=a212c25811ff0694d76573252ffcda63d0816ebd
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 2e973f6..a600948 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -664,9 +664,17 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
Loaded Bibliographic Records
bibs
0
- Count.Loaded
- SELECT COUNT(bre.id), bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre WHERE id IN (SELECT id FROM biblio.record_entry WHERE deleted = FALSE) GROUP BY 2 ORDER BY 2
- False means the records are not deleted.
+ Count
+ SELECT COUNT(bre.id) FROM biblio_record_entry_legacy bre WHERE id IN (SELECT id FROM biblio.record_entry) ORDER BY 1
+
+
+
+ bibs_loaded
+ Loaded Bibliographic Records
+ bibs
+ 1
+ Count
+ SELECT COUNT(bre.id) FROM biblio_record_entry bre WHERE id IN (SELECT id FROM biblio.record_entry) ORDER BY 1
@@ -676,6 +684,16 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
0
Count
SELECT COUNT(id) FROM biblio_record_entry where id NOT IN (SELECT DISTINCT record FROM asset_call_number)
+ These records would not have been loaded.
+
+
+
+ bibswuri
+ Bibliographic Records With 856$9s
+ bibs
+ 0
+ Count
+ SELECT COUNT(id) FROM biblio_record_entry where id IN (SELECT record FROM asset.call_number WHERE label ~* '##URI##')
@@ -742,12 +760,12 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- bib_merges_by_search_format
+ bib_merges_searchformat
Bibliographic Merges By Search Format
bibs
0
Count.Item Type
- WITH g AS (SELECT UNNEST(records) FROM groups) SELECT COUNT(record), search_format_str FROM dedupe_batch WHERE record IN (SELECT * FROM g) GROUP BY 2
+ DROP TABLE IF EXISTS temp_unnest; CREATE TABLE temp_unnest AS (SELECT UNNEST(records) FROM groups); SELECT COUNT(record), search_format_str FROM dedupe_batch WHERE record IN (SELECT * FROM temp_unnest) GROUP BY 2 ORDER BY 2