This line
db.comentario_vendedor.vendedor_id.requires=IS_IN_SET(db(db.auth_user.profesional=='True').select(db.auth_user.first_name))
should be
db.comentario_vendedor.vendedor_id.requires=IS_IN_DB(db(db.auth_user.profesional=='True'),auth_user.first_name)
On Nov 20, 6:43 am, puercoespin <jzaragoza.puercoes...@gmail.com>
wrote:
> Hello,
>
> I have a custom db.auth_user, with a boolean field
>
> """
> ....
> Field('profesional', 'boolean', default=False),
> .....
> .....
> format='%(first_name)s',
>
> )
>
> """
>
> and a table that references:
>
> '''
> db.define_table('comentario_vendedor',
> Field('vendedor_id', db.auth_user,),
> ....
>
> ''''
>
> I want to display in 'vendedor_id' only db.auth_user.profesional=True,
> so:
>
> '''
> db.comentario_vendedor.vendedor_id.requires=IS_IN_SET(db(db.auth_user.profesional=='True').select(db.auth_user.first_name))
> '''
> But I display <Row {'firs_name':'nombrevendedor1'}> <Row
> {'firs_name':'nombrevendedor2'}> etc.
>
> Where's the error?
>
> Thanks!
