[web2py] Re: Options for displaying large database tables (jqGrid issues)

2012-09-25 Thread Dominic Cioccarelli
Ciao Massimo, yes, I actually stumbled upon smartgrid yesterday afternoon, although some pointers to some examples and documentation would still be appreciated. In particular, things linked linked tables, specifying which columns are displayed and specifying how column values are hyper linked t

[web2py] Re: Options for displaying large database tables (jqGrid issues)

2012-09-24 Thread Massimo Di Pierro
:-) Did you try? # in controller query = db.server # or more complex filter grid = SQLFORM.grid(query) # in view {{=grid}} It will do pagination, searching, etc. If you are logged in, it will also allow create/edit/update. There is a also a SQLFORM.smartgrid. On Monday, 24 Sep