<report_title>Action Triggers Setup for Notices</report_title>
<heading>ID.Active.Owner.Name</heading>
<query>SELECT ed.id, ed.active, aou.shortname, ed.name
- FROM m_action_trigger.event_definition ed
+ 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 m_actor_usr)
OR ed.owner IN (SELECT DISTINCT parent_ou FROM actor.org_unit WHERE id in (SELECT DISTINCT home_ou FROM m_actor_usr));
<report_title>Count of Notices Run with State</report_title>
<heading>Count of Notices.State.ID.Owner.Name</heading>
<query>SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, ed.name
- FROM m_action_trigger.event_definition ed
+ FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
- JOIN m_action_trigger.event ate ON ate.event_def = ed.id
+ JOIN action_trigger.event ate ON ate.event_def = ed.id
WHERE ed.owner IN (SELECT DISTINCT home_ou FROM m_actor_usr)
OR ed.owner IN (SELECT DISTINCT parent_ou FROM actor.org_unit WHERE id in (SELECT DISTINCT home_ou FROM m_actor_usr))
GROUP BY 2,3,4;