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
luk I can confirm the problem with querying from the roles collection with a node.id constraint. I tried with board, category and community node ids that I took from the valid results from a "SELECT * FROM roles" query, but for all simply get an empty success result set.
luk Sorry for the delayed response. I'm seeing the same thing in my test community. I'm raising this with the Engineer who added the constraint.
I spoke with the Engineer who added the constraint.
I think the best way to address this is to file a Support ticket and call this out as a bug. We added the constraint and it is does not seem to be implemented in a way that a customer using the Community API could make use of it. The engineer wasn't able to provide a satisfactory workaround either.
EDIT: The Engineering team is planning to remove the 'node.id' constraint from the public documentation. If you feel that this is in error, definitely file a feature enhancement or a bug to pursue the issue. Having a customer on a ticket carries more weight.
Thank you for bringing it to my attention.
