Forum Discussion

Claudius's avatar
Claudius
Boss
6 years ago

LiQL: Exclude users with certain rank

I am building a user leaderboard component and exclude users with certain ranks. Unfortunately I cannot find a constraint to exclude users by rank. These did not work:   SELECT * FROM users WHERE...
PAULEM's avatar
PAULEM
Advisor
6 years ago

Hi Claudius 

I had a play with the ranks "table" and this worked:

SELECT * FROM users WHERE rank.id IN ('2','3','4') ORDER BY kudos_received.sum(weight) DESC

While not elegant, maybe this would serve?  Assuming "Administrator" has an ID of "1", leaving it out of the list would exclude Administrators from the results.