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...
Forum Discussion
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.
This would be another workaround, but hard to manage since we have 26 ranks right now and I don't want to create a future dependency to update the code any time we change the rank structure. Ideally we should be able to just exclude ranks in the query via negation already.
