Although this is working:
db.audienceInstances.instances.requires=IS_IN_DB(db(db.instance.type==auth.user.product),'instance.id',multiple=True)
Is only showing ids , disregarding of the format defined here:
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))
IS there any way to fix that?
Thanks,
Nico
On Thu, Jul 14, 2011 at 1:45 PM, Anthony <[email protected]> wrote:
> 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
>
