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,
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

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.


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