ReportSQL - Case Exclusions Field

The Case Exclusions field is not yet available in the report UI.

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)