I'm trying to do the same, can anyone help?
On Friday, June 28, 2013 at 3:03:12 AM UTC+2, fun man wrote: > > Hi all, > > I have a couple tables joined in the sqlform.grid. They both have around > 20 fields. I am only displaying around 10~15 fields for a particular > purpose. > > When I click on the search widget, it gives me way more option that I need > (all the 40 fields to choose from). > > Is there a possible way that I could pass a list of "searchable fields" to > the search widget? The current search widget is great, and I hope not to > re-create it for only searching for less fields. > > Many thanks > funman > > schedule = SQLFORM.grid( query, \ > left=[db.order_item.on(db.order_item.purchase_id == > db.purchase.id)],\ > user_signature=True,\ > fields=[db.purchase.id, db.purchase.facility_id, > db.purchase.supplier_id, \ > db.purchase.pr, db.purchase.so, > db.purchase.quote_ref, db.purchase.funding, \ > db.order_item.product_partnum, db.order_item.status, > db.order_item.quantity, db.order_item.qtdqtyship, \ > db.order_item.schedule_shipdate, > db.order_item.hold_info, > ],\ > exportclasses=dict(csv_with_hidden_cols=False,xml=False, > html=False, tsv_with_hidden_cols=False, tsv=False, json=False),\ > showbuttontext=False, create=False, editable= False, > deletable = False, details=False,searchable = True, > ) > > > -- 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.
