Left out the 'name' field in the 'script' file when I boiled down my
example. Doesn't affect the issue at hand, but just to be clear:
db.define_table('script',
Field('name'),
Field('configs', 'list:reference config'),
format='%(name)s')
- Michael
On Wednesday, July 10, 2013 3:54:34 PM UTC-4, Michael Nagy wrote:
>
> A simplified view of my db schema, with a 'config' table and a 'script'
> table that defines a 'configs' field that references a list of 'config'
> records (multiple=True). I want to be able to use multiple-selection
> listbox to edit the list of references on a 'script' record, and have the
> list box display the formatted representation of the entries in the
> 'config' table as per the format_config() function defined for the 'config'
> table. I have multiple selection working fine, but nothing I have tried
> (after a lot of googling) will change what the entries in the
> multiple-selection listbox actually look like (I am using a vanilla SQLFORM
> edit form).
>
> What am I missing? Here are my definitions (simplified):
>
> db.define_table('config',
> Field('name'),
> Field('detail'),
> format=lambda r: format_config(r)
> )
>
> def format_config(record):
> return '%s %s' % (record.name, record.detail)
>
> db.define_table('script',
> Field('configs', 'list:reference config'),
> format='%(name)s')
>
> db.script.configs.requires = IS_IN_DB(db, db.config, '%(name)s',
> multiple=True)
> db.script.configs.represent = lambda r: format_config(r)
>
> I would expect that some magic in the last line should allow me to control
> the representation of the items in the multiple-selection listbox, each of
> which should be a 'config' table reference, but nothing I have tried works
> - I always end up with the 'config.name' field only, without the
> additional 'config.detail' field that I need. I can't seem to figure out
> how to reference the items in the list of configs within the lambda, or
> something.
>
> - Michael
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
