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, ) -- --- 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.