You need to fetch the ID of the desired group *group = db(db.auth_group.role == 'managers').select().first().id*
define a DAL set using the group id to query membership table *dbset = db(db.auth_membership.group_id == group)* include IS_IN_DB validator filtering by the DAL set *db.Mytable.manager.requires = IS_IN_DB(dbset, 'auth_membership.user_id') * May be there is a shortcut for doing this... On Sun, Nov 20, 2011 at 6:37 PM, petrasadi <[email protected]> wrote: > In my table a have a field like this: Field('manager', 'reference > auth_user') > Is there a way to enforce in my db for this 'manager' to be part of > the "managers" group? > I have tried db.myTable.manager.requires_membership('managers'), but > of course this blew up. > Any ideas would be highly appreciated. > -- Bruno Rocha [http://rochacbruno.com.br]
