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.
