Hello Rudy,
I am not sure I understand what you mean by : "I can write an action
select_quote_by_name() to address it"
But, you sould be able to use "company" reference field representation like
so :
db.define_table('quotation',
Field('company', 'reference company',
represent=lambda id, row:
db.company(id).company_name if id else T('N/A')),
Field('project_name', requires=IS_NOT_EMPTY()),
Field('quote_amount', 'double', default=0, writable=False))
This should show company_name in grid and you should be allow to search
with company name in the search widget.
Richard
On Thu, Apr 27, 2017 at 1:03 PM, Rudy <rudyle...@gmail.com> wrote:
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
