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.


Reply via email to