[web2py] SQLFORM.grid: Search only startswith

[Omi Chiba]

For example, I have a field which has 'abcab' and 'bcabc' data.
If I provide 'ab' in the search box, I want to just pull the first one
('abcab') and exclude second one ('bcabc'). Can we do this ?


models/db.py
---------------------
db.define_table('Product',
    Field('Part_Number'))

controllers/default.py
------------------------------
def admin():
    products = SQLFORM.grid(db.Product,deletable=False, paginate=10)
    return dict(products = products)