Hi lovely people! :smiley: Using the data explorer is it possible to display in a table of what user(s) have muted and ignored and by whom? If anyone could lend a hand I’d be really grateful :heart: Thanks

Try: SELECT id AS user_id, muted_users, ignored_users FROM ( SELECT u.id, ARRAY_AGG(m.muted_user_id) FILTER (WHERE m.muted_user_id IS NOT NULL) AS muted_users, ARRAY_AGG(i.ignored_user_id) FILTER (WHERE i.ignored_user_id IS NOT NULL) AS ignored_users FROM users u LEFT JOIN ignored_users i ON u.id = i.user_id LEFT JOIN muted_users m ON u.id = m.user_id GROUP BY u.id ) data WHERE (muted_users IS NOT NULL OR ignored_users IS NOT NULL) OR, if you want a list of usernames instead of ids, try: SELECT id AS user_id, muted_users, ignored_users FROM ( SELECT u.id, ARRAY_AGG(muteds.username) FILTER (WHERE muteds.username IS NOT NULL) AS muted_users, ARRAY_AGG(ignores.username) FILTER (WHERE ignores.username IS NOT NULL) AS ignored_users FROM users u LEFT JOIN ( SELECT i.user_id AS id, u1.username FROM users u1 INNER JOIN ignored_users i ON u1.id = i.ignored_user_id) ignores ON u.id = ignores.id LEFT JOIN ( SELECT m.user_id AS id, u1.username FROM users u1 INNER JOIN muted_users m ON u1.id = m.muted_user_id) muteds ON u.id = muteds.id GROUP BY u.id ) data WHERE (muted_users IS NOT NULL OR ignored_users IS NOT NULL)

Haven’t seen this as a feature before, and I doubt it will be added or it could jeopardize safe privacy practices.

List who muted / ignored users

Community Building Data & reporting

ondrej October 24, 2021, 10:12am 4

Thanks Robert for creating the query! The username one works better for us.
Have a great day

Topic		Replies	Views
Dashboard Report - Top Ignored / Muted Users Data & reporting sql-query , dashboard-reports , dashboard-sql	0	343	January 31, 2024
Ignored vs. Muted users Product Support	2	754	January 29, 2024
Possible to MUTE users? Product Support	6	1319	November 8, 2021
Topics created by ignored users showing on homepage Feature	24	3880	May 26, 2026
How can I Mute and/or Ignore an Inactive user? Product Support	9	624	January 27, 2024

List who muted / ignored users

Related topics