Hi there,
I have a quotation table which references the company table. When i created
a SQLFORM.grid, I couldn't use the company_name as keyword in the default
search widget as company field in the quotation table is integer type (id)
even though it's displayed as company_name. I can write an action
select_quote_by_name() to address it, but I wonder if there is any simple
way to address this matter while I can still leverage the default search
widget? Thanks in advance!
db.define_table('company',
Field('company_name', requires=IS_NOT_EMPTY()),
format='%(company_name)s')
db.define_table('quotation',
Field('company', 'reference company'),
Field('project_name', requires=IS_NOT_EMPTY()),
Field('quote_amount', 'double', default=0, writable=False))
grid=SQLFORM.grid(db.quotation)
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
