User Status

announcements
,
53

As long as you have the data-explorer plugin it’s pretty simple. :+1: (you just have to remember to run it)

The simplest query would be:


SELECT *
FROM user_statuses
ORDER BY set_at DESC

Or you could have a swisher one with a direct link to the user’s Preferences/Account page. eg:


SELECT us.user_id,
       us.emoji, 
       us.description,
       'https://meta.discourse.org/u/' || u.username || '/preferences/account' AS preferences_account_url
FROM user_statuses us
JOIN users u ON u.id = us.user_id
ORDER BY set_at DESC
7 Likes