Forum Discussion

keithkelly's avatar
keithkelly
Leader
2 years ago

Impossible to list User Roles from single "from users" API call?

I'm trying to emulate the User Report that lists users, ids, etc & roles like so: SELECT login, id, topics.count(*), messages.count(*) FROM users including "roles" just gives the implicit join qu...
REST API v2 & LiQL
Hoekstra_VFZ's avatar
Hoekstra_VFZ
Advisor
2 years ago

Yeah, the role is not in users but in roles:

SELECT name FROM roles WHERE users.id = ''

I have made a component that displays the role as well the rank in the avatar section of a message. For non-admin users to see the role, it was needed to perform above query using restadmin instead rest.