requires for dropbox control representation (in you requires : '%(name)s'
is what determine what are you option format)
represent for representation on select
Richard
On Thu, Jul 11, 2013 at 4:18 PM, Michael Nagy <mn...@voalte.com> wrote:
> Ok, figured it out. The format specifier in the 'requires' is the magic
> one, not the one in the 'represent'. So my original:
>
> db.script.configs.requires = IS_IN_DB(db, db.config, '%(name)s',
> multiple=True)
>
> Became:
>
> db.script.configs.requires = IS_IN_DB(db, db.config, lambda r:
> format_config(r), multiple=True)
>
> Where format_config(r) is like:
>
> def format_config(r):
> return '%s %s' % (r.name, r.detail)
>
> - Michael
>
>
> On Wednesday, July 10, 2013 3:58:54 PM UTC-4, Michael Nagy wrote:
>>
>> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
