Forum Discussion

micha80's avatar
micha80
Expert
11 years ago

Condition for more then one role

Hi,   I want to generate a custom leaderboard based on role conditions. The Leaderboard should only show member which have two specific roles assigned. For this I gave the API v2 a chance and creat...
OlivierS's avatar
OlivierS
Lithium Alumni (Retired)
11 years ago

micha80 Try to use the clause 'IN' per the User Resource example:

 

SELECT id, login FROM users WHERE roles.name='Administrator'
SELECT * FROM users WHERE roles.name IN ('Administrator', 'Community Manager')
PaoloT's avatar
PaoloT
Lithium Alumni (Retired)
11 years ago

Hi micha80

 

if that is indeed the behavior you are seeing, I think you should flag this with support as a possible bug. Thanks,