Collections: All Collections Triggers for a Given Firm

Description: This query finds all the collections triggers for a firm.

Query:

-- Search for a firm's triggers, both old and new ones
SELECT ad.description, r.is_active, r.created_at, r.updated_at ,r.priority
FROM action_def ad
inner join action_def_group_action_def adgaf on ad.id = adgaf.action_def_id
inner join action_def_group adg on adg.id = adgaf.action_def_group_id
inner join rule r on r.action_def_group_id = adg.id
WHERE
rule_key = 'RuleExpression' and is_active
ORDER BY is_active, priority