any alternatives?
On Wed, Jul 13, 2011 at 3:39 PM, Nicolas Palumbo <napalu...@gmail.com> 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
>
