I was wondering how to select all users not in a group with a certain role. I tried using:
db(db.auth_group.role=='site_admin')(db.auth_membership.group_id==db.auth_group.id)(db.auth_membership.user_id!=db.auth_user.id).select(db.auth_user.id, db.auth_user.first_name, db.auth_user.last_name, db.auth_user.email, distinct=True).as_list() But this doesn't seem to work, though I am unsure why (can someone also help me on the reasoning behind this?) Thank you in advance! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
