ReportSQL - Case Exclusions Field
Not needed as of 2026-11-13.
The Case Exclusions information is available in two fields on the top level Case Data table: Case Exclusion Names and Case Exclusion User IDs.
A concatenated list of user names:
- Text formula field on Case Data
(SELECT string_agg(
concat_ws(' ', p.first, p.middle, p.last),
', '
ORDER BY p.last, p.first
)
FROM matter_user_view_exclusions me
JOIN users u ON me.user_id = u.id
JOIN person p ON u.person_id = p.id
WHERE me.matter_id = %tableAlias%.id)
If you'd rather get user IDs:
(select string_agg(matter_user_view_exclusions.user_id::text, ', ') from matter_user_view_exclusions join matter on matter.id = matter_user_view_exclusions.matter_id where matter_id = %tableAlias%.id)