REST V2 query for online users

Question

Is there a way to get only online users from the database using API V2? I would normally use a WHERE online_status = 'online' but this returns offline users too! My query is also not suitable as it takes the first 1000 and loops to find online users. I have a database of 30,000 members and this just wont do. Here is my query for my component.

<#assign query = "SELECT login, view_href, avatar, online_status, registration_data, rank FROM users limit 1000" />

Can anyone suggest a way of modifying my query to only get online users?

chiaras · Answer

Sounds like a bug, since it's documented here as supported (http://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&amp;collection=users#constraints-online_status).
/cc&nbsp;SuzieH&nbsp;
&nbsp;
As a workaround, I would use v1:&nbsp;http://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv1&amp;leaf-id=Community.users.online#Community.users.online

chiaras · Answer

hi,
&nbsp;
no it's not possible within the same call. You would need to perform a "dedicated" call for each user to get the id:&nbsp;/users/id/&lt;id&gt;/ranking/id

jaread83 · Answer

Thanks ChiaraS but I need to use V2 to get the rank ID's back for my loop as I have applied classes to each container for some of the upper ranked users (mods, admins, VIPs etc). I did use V1 but couldn't figure out how to get the rank IDs back. Is there a way to get the rank ID in V1? I could post my full component here if that would help?

jaread83 · Answer

Thank you very much! I have converted my entire V2 api component to V1 and it all seems to be working as expected now.Thank you for your time!

Forum Discussion

REST V2 query for online users

Related Content

query with date field

query any user's online status

Issues with batched queries

/users/online vs. /users/online/count

Users not receiving Atlas emails

Recent Discussions

Will adding/changing a custom tag trigger a Community event?

How to convert Endpoints to GraphQL queries?

Error message when adding a query to handlebars component (Aurora)

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?