X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=ecdc30a6856d468ec76a66331d54ee23d4bee6c4;hp=a600948c7d037be68ccc814b1679c63e8af36fe9;hb=ae0cbef8cb836900fc8b70b8a4c58cb97021c0be;hpb=fa26b7ca39c2535d858a3ae1b3b369f4b7dca2a1
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index a600948..ecdc30a 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -1159,9 +1159,9 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
notices_overview
notices
0
- Overview of Notices for Migration
- ID.Active.Owner.Name.Delay.Validator.Reactor
- SELECT ed.id, ed.active, aou.shortname, LEFT(ed.name,25) || '...', ed.delay, ed.validator, ed.reactor
+ Action Triggers Setup for Notices
+ ID.Active.Owner.Name
+ SELECT ed.id, ed.active, aou.shortname, ed.name
FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
WHERE ed.owner IN (SELECT DISTINCT home_ou FROM actor_usr)
@@ -1175,7 +1175,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
0
Count of Notices Run with State
Count of Notices.State.ID.Owner.Name
- SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, LEFT(ed.name,25) || '...'
+ SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, ed.name
FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
JOIN action_trigger.event ate ON ate.event_def = ed.id