Silenced_till reason

I was to query for why users were silenced. I tried to take an educated guess and search for fields with silence in the name but I’m still not seeing it:

select t.table_schema,
       t.table_name
from information_schema.tables t
inner join information_schema.columns c on c.table_name = t.table_name
                                and c.table_schema = t.table_schema
where c.column_name LIKE 'silence%'
      and t.table_schema not in ('information_schema', 'pg_catalog')
      and t.table_type = 'BASE TABLE'
order by t.table_schema;
1 Like

Try this:

SELECT acting_user_id, target_user_id AS silenced_user_id, details AS reason, created_at
FROM user_histories
WHERE user_histories.action = 30
6 Likes

Thank you. I didn’t think to look at user_histories as I thought it would be their history and not the history of actions taken against them.

2 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.