[web2py] grouping and counting

In a table definition I have the following field: db.define_table('app_settings', ... Field('viewtypeID', type='integer', requires=IS_IN_SET(viewtype_list)), ... migrate = False) This is the viewtype_list: viewtype_list = [(1, 'zero'), (2, 'thing'), (3, 'client'), ..., (8, 'hub')]

[web2py] Grouping and counting using sqlform grid

hi, i want to use grouping and counting using sqlform grid. while i'm searching and learning on this forum i made something like: purchase_order_left = db.purchase_order_header.on(db.purchase_order_header.supplier==db.supplier.id) #purchase_order_left = db.purchase_order_header.on(db.purchase_