Why aren't warnings easily accessible like suspensions are?

Community
9

We implemented a temporary solution using the Data Explorer plugin. I wrote a query that returns a list of warning for a particular user:

-- [params]
-- string :username
select topic_id
from user_warnings
join users u on user_id = u.id
where username = :username

Then I made query available to moderators. That way they can go to /g/moderators/reports, pick the report for official warnings and enter a usename. It’s not quite as nice as being able to click the “1 warnings” text on a profile, but it does give moderators access to the information they need.

5 Likes