[web2py] Re: Select from auth_user with auth.has_membership condition

On Thursday, December 22, 2016 at 5:13:17 AM UTC+1, antonel...@yottacle.com wrote: > > Hi, > in my model I have users who have membership to more groups. > I am trying to perform a query of users who DO NOT belong to a group; > something along these lines: > > query = db ((db.auth_user !=

[web2py] Select from auth_user with auth.has_membership condition

Hi, in my model I have users who have membership to more groups. I am trying to perform a query of users who DO NOT belong to a group; something along these lines: query = db ((db.auth_user != auth.user.id) & (~(auth.has_membership ("admin", db.auth_user.id))).select (db.auth_user.first_name,