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))
db.railLoad.loadedById.requires = IS_IN_DB(db(userQuery),
'auth_user.id', ....
On Thursday, April 19, 2012 5:06:18 PM UTC-4, Jim S wrote:
Hi
I'm looking for the most concise syntax to get a list of users
that have
a a certain permission.
Here is what I have:
groups =
db((db.auth_permission.name
<http://db.auth_permission.name>=='load')&(db.auth_permission.table_name=='railLoad'))._select(db.auth_permission.group_id)
userids =
db(db.auth_membership.group_id.belongs(groups))._select(db.auth_membership.user_id)
userQuery = db.auth_user.id.belongs(userids)
db.railLoad.loadedById.requires = IS_IN_DB(db(userQuery),
'auth_user.id <http://auth_user.id>',
'%(lastFirst)s',
zero='...choose
one...')
What I'm doing is filtering a dropdown. Want to limit the
selections to
just the people with a specific permission. This way works, but
seems
like too much code for something in web2py.
-Jim
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2012.0.1913 / Virus Database: 2411/4939 - Release Date: 04/15/12
--
Jim Steil
VP of Information Technology
Quality Liquid Feeds, Inc.
608.935.2345 office
608.341.9896 cell
