X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=da9f83c4de969674e0b4793b1a5afab7615e1805;hp=0430f0c859e3fc3c22a0c826231b44ed4908ee45;hb=057ef949547ddd269dc59e629049ab0eb35834db;hpb=50d340ed08c0d30520b76ef163827e7afd90d5ca
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 0430f0c..da9f83c 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -528,6 +528,15 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
SELECT COUNT(map.id), tag.tag_type, tag.label, tag.staff_note, tag.pub FROM asset_copy_tag tag JOIN asset_copy_tag_copy_map map ON map.tag = tag.id GROUP BY 2,3,4,5 ORDER BY 2,3
+
+ asset_copy_alerts
+ Copy Alerts
+ assets
+ 0
+ Alert Count.Alert Type
+ SELECT COUNT(*), cat.name FROM asset_copy_alert aca JOIN config.copy_alert_type cat ON cat.id = aca.alert_type GROUP BY 2
+
+
@@ -723,6 +732,24 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
SELECT COUNT(b.id) FROM biblio_monograph_part b
+
+ bib_merges
+ Bibliographic Merge Count
+ bibs
+ 0
+ Records Merged.Incumbent Records Merged Into
+ SELECT SUM(array_length(records,1)), COUNT(*) FROM groups
+
+
+
+ bib_merges_by_search_format
+ 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
+
+