Forum Discussion

Advisor

8 years ago

Solved

How to get count of users in rank

I did find an API to get count of users in each rank.

Can someone help with this

Payal
8 years ago
Hi tsrisudh,

You can use the following api to get count of users in each rank:

SELECT count(*) FROM users WHERE rank.name = 'Community Manager'

Thanks,

3 Replies

AbhishekIlindra
Boss
8 years ago
Hi, Kindly check this post for more information https://community.lithium.com/t5/Developer-Discussion/Get-the-list-of-Ranks-for-Each-user-in-Lithium/m-p/321631 Thanks, Abhishek
Sign in to react to this post
Payal
Director
8 years ago
Hi tsrisudh,

You can use the following api to get count of users in each rank:

SELECT count(*) FROM users WHERE rank.name = 'Community Manager'

Thanks,
Sign in to react to this post
tsrisudh
Advisor
8 years ago
AbhishekIlindra This gives list of rank for users and not users in rank
Sign in to react to this post