Re: [web2py] Re: List of users with a specific permission

2012-04-20 Thread Jim Steil
Thanks Johann Had to modify to also add (db.auth_group.id==db.auth_membership.group_id) db((db.auth_user.id==db.auth_membership.user_id)&(db.auth_group.id==db.auth_permission.group_id)&(db.auth_permission.name=='load')).select(db.auth_user.id, distinct=True) Thanks again for getting me down t

Re: [web2py] Re: List of users with a specific permission

2012-04-20 Thread Johann Spies
On 20 April 2012 15:37, Jim Steil wrote: > That's not quite it either. This is checking for a group 'role' as > opposed to looking for all users that have a specific permission > (auth_permission). > Then adapt it. Determine the group name that have the specific permission and from there it is

Re: [web2py] Re: List of users with a specific permission

2012-04-20 Thread Jim Steil
That's not quite it either. This is checking for a group 'role' as opposed to looking for all users that have a specific permission (auth_permission). -Jim On 4/20/2012 2:27 AM, Johann Spies wrote: On 20 April 2012 03:07, Jim Steil mailto:j...@qlf.com>> wrote: No, I'm looking for a

Re: [web2py] Re: List of users with a specific permission

2012-04-20 Thread Johann Spies
On 20 April 2012 03:07, Jim Steil wrote: > No, I'm looking for a list of user ids. I don't want to filter by user > id. > > In [25]: reds = [x.id for x in db((db.auth_user.id == db.auth_membership.user_id)&(db.auth_group.id == db.auth_membership.group_id) & (db.auth_group.role == 'kb_ed')).sele

Re: [web2py] Re: List of users with a specific permission

2012-04-19 Thread Jim Steil
No, I'm looking for a list of user ids. I don't want to filter by user id. -Jim On 4/19/2012 5:08 PM, Cliff wrote: Something like this: userQuery = ((db.auth_permssion.name=='load') & (db.auth_permission.group_id==db.auth_membership.group_id) & (db.auth_membership.user_id==db.auth_user.id

[web2py] Re: List of users with a specific permission

2012-04-19 Thread Cliff
Something like this: userQuery = ((db.auth_permssion.name=='load') & (db.auth_permission.group_id==db.auth_membership.group_id) & (db.auth_membership.user_id==db.auth_user.id)) db.railLoad.loadedById.requires = IS_IN_DB(db(userQuery), 'auth_user.id', On Thursday, April 19, 2012 5:06