Custom Component Number of experts online
Hi, I would like to add a custom component on the home page that shows the number of experts (defined by ranks or roles) who are currently online and their avatars. Is this feasible with the API, a...
Forum Discussion
Well, a query like the one provided by steffenschoene this will give you data to work with
SELECT id, online_status, last_visit_time, href FROM users WHERE roles.name='Administrator' AND last_visit_time > 2023-02-25T00:00:00.000-07:00 ORDER BY last_visit_time DESC LIMIT 100
the problem is that the field "online_status" is absurdly unreliable, i just checked in one of our communities, there are "online" users with a last_visit_time in 2020 🙄...
so do NOT rely on what that field says, so i'd probably use a combination of "online" and "last_visit_time" to filter out a more reasonable subset of users that might be online, e.g. like i adapted the query above. Still doesn't mean that user is still online though... I assume online_status is determined by session and maybe if someone checks "remember me" when logging in, the session does not expire for a long time, so that user just "stays" online in the eyes of Khoros. But that's only speculation.
