I am trying to ban or unban a user from my program. When I ban the user, I grant the permission called ban on an object id for a party id. So I can fetch the list of banned users by saying -
..where privilege = 'ban'.
However when I want to find out the users who are not banned, if I say ...fetch users where privilege != 'ban', I get banned users along with the unbanned users.
Can anyone please suggest me a solution, how can I separate banned users from unbanned users. I basically want 2 lists.. so if I ban a user, its name should appear in the list of UNBAN this user and whereas if I unban a user its name should appear in the list BAN this user.
I hope I have made myself clear. Any suggesstions are appreciated. I know of a way but its not elegant and its not what I exactly want.