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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.