X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=b6f58f0727564ec9f30e4e644286c2ecc94d8dbb;hp=1a75e3e5069e70e98f3fbc10ebba3cb081c08650;hb=16a82253bc9014f64bd07e05077ee2b4b0b7f810;hpb=5b5278e6024c476c0ed7331a43fcd52f8a7a8232
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 1a75e3e..b6f58f0 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -44,9 +44,20 @@
circ_count
circs
0
- Open Circulations
- Circulation Status.Migrated.Count of Circs
- SELECT 'Closed Circulations', x_migrate::TEXT, COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NOT NULL GROUP BY 2 UNION ALL SELECT 'Open Circulations', x_migrate::TEXT, COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL GROUP BY 2
+ Migrated Circulations
+ Circulation Status.Count of Circs
+ SELECT 'Closed Circulations', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NOT NULL AND x_migrate
+ UNION ALL SELECT 'Open Circulations', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate
+
+
+
+ circ_count_unmigrated
+ circs
+ 0
+ Open Un-migrated Circulations
+ Circulation Status.Count of Circs
+ SELECT 'No Matching User', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate = FALSE AND usr IS NULL
+ UNION ALL SELECT 'No Matching Item', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate = FALSE AND target_copy IS NULL
@@ -304,6 +315,15 @@
+ asset_precat
+ Precats (AKA Copies Without Bibs)
+ assets
+ 0
+ Copy Count.Migating
+ SELECT COUNT(ac.id), ac.x_migrate::TEXT FROM asset_copy_legacy ac WHERE ac.x_bre_id = -1 GROUP BY 2
+
+
+
asset_circ_mod_copies_count
Copies by Circulation Modifier
assets