Hi Anthony, Thanks for your advises, I'll try the searchable argument function first to leverage the built in search widget, i do find it very handy.
On Wednesday, May 3, 2017 at 12:36:15 AM UTC+8, Anthony wrote: > > The grid takes a "searchable" argument, which can be a function that > generates a DAL query based on the submitted keywords and the fields. For > an example, see the default search function: > https://github.com/web2py/web2py/blob/baa129f8715a9d126a81e7ce098d349894d65baa/gluon/sqlhtml.py#L1922 > . > > You can also substitute the default search widget with a custom widget via > the "search_widget" argument. For an example, see the default widget: > https://github.com/web2py/web2py/blob/baa129f8715a9d126a81e7ce098d349894d65baa/gluon/sqlhtml.py#L1955 > . > > Anthony > > On Thursday, April 27, 2017 at 1:03:46 PM UTC-4, Rudy 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.
