db.class_attendant.person_id.requires = IS_IN_DB(db(db.person.age >= 18),
'person.id', '%(name)s %(surname)s')
The first argument to IS_IN_DB and IS_NOT_IN_DB can be a Set object rather
than an entire db connection. See
http://web2py.com/books/default/chapter/29/7#Database-validators.
Anthony
On Thursday, May 31, 2012 2:49:35 PM UTC-4, José L. wrote:
>
> Hi, I'm using a referenced table with IS_IN_DB validator, but I'd like to
> filter the fields to be shown in the combo list.
> As an example:
>
> db.define_table('person',
> Field('name'),
> Field('surname),
> Field(age,'integer')
> )
>
> db.define_table('class_attendant',
> Field('Date','date'),
> Field('Classname'),
> Field('person_id',db.person,readable=True,writable = True,
> label="User"))
>
> db.class_attendant.person_id.requires = IS_IN_DB(db,'person.id','%(name)s
> %(surname)s')
>
> When using a SQLFORM(db.class_attendant) to add new persons to the
> class_attendant table, the combo list shows all the persons in the person
> table, but I'd like it to show only the persons whose age is upper than 18.
> What's the best method to do it?
>
>
