The default validator for a list:reference field is
IS_IN_DB(db,'<table>.id',multiple=True). Instead of db, you can pass a DAL
Set to that validator to filter the returned list -- something like:
db.audienceInstances.instances.requires=IS_IN_DB(db(db.instance.type==current_profile.type),'instance.id',multiple=True)
See http://web2py.com/book/default/chapter/06#DAL,-Table,-Field and
http://web2py.com/book/default/chapter/07#Database-Validators.
Anthony
On Wednesday, July 13, 2011 2:39:50 PM UTC-4, Nico Palumbo wrote:
> I have currently this multiselect generated by list:references:
>
> db.py:
>
>
> db.define_table('instance',Field('app',db.application),Field('server',db.server),Field('type','string'),format=lambda
> r: '%s %s' %(db.application[r.app].name,db.server[r.server].hostname))
> ...
> db.define_table('audienceInstances', Field('instances','list:reference
> instance'),Field('user',db.auth_user,writable=False, readable=False))
>
> default.py:
>
> monitoredInstances = db.audienceInstances(db.audienceInstances.user ==
> auth.user.id)
> #Generates a form for the updation of the list of monitored instances
> instancesForm = SQLFORM(db.audienceInstances, monitoredInstances,
> submit_button='Update', showid=False)
> if instancesForm.accepts(request.vars, session):
> response.flash = 'list updated'
> elif instancesForm.errors:
> response.flash = 'form has errors'
>
> That shows a list select among all instances. But what if I'd like to
> show a subset of that list, I mean I added a type field in instance
> table, and like to get the instances of the type the user has selected
> in its profile.
>
> The only way I can think of is creating a separate audienceInstances
> table for each type. Is there any othere way?
>
> Thanks,
> Nico
>
>
