:-)
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 September 2012 09:11:14 UTC-5, Dominic Cioccarelli wrote:
>
> Hi all,
>
> I'm pretty new to web2py, so please go easy ;-)
>
> I'm looking for a plugin to help with the display of database tables.
> Specifically, it needs to support very large tables, so pagination,
> searching, etc. needs to be done on the server side.
>
> I first looked at PowerGrid <http://labs.blouweb.com/PowerGrid/> but the
> site seems to be down and from what I could see the last version didn't
> support server side pagination (so unacceptably slow for large tables).
>
> I then started looking at the DataTables plugin but that seemed a less
> mature version of PowerGrid.
>
> Then I looked at jqGrid and Editable
> jqGrid<http://ebansoftware.net/it/prodotti/item/9-editable-jqgrid> and
> then realised that they had been merged into the plugin_wiki's jqGrid, so I
> tried that. Unfortunately I'm having some issues. My model is pretty simple:
>
> db.define_table('server',
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('server_id','id'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('server_name'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('hpsa_server_id',
> 'integer'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('mesh_id',
> 'integer'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('customer_id',
> 'integer'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('facility_id',
> 'integer'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('active',
> 'boolean'),
> Field
> <https://automationservices.ssn.hp.com/examples/global/vars/Field>('modified_date',
> 'datetime'),
> migrate=False)
>
>
> The controller (server.py) is as follows:
>
> def index():
> response
> <https://automationservices.ssn.hp.com/examples/global/vars/response>.flash =
> "Welcome to the server view!"
> return dict(servers=plugin_wiki.widget('jqgrid',table='server'))
>
> And the index view is as follows:
>
>
> {{extend 'layout.html'}}
>
> {{=servers}}
>
>
> The problem is that the table is rendering with the correct columns but no
> data. Chrome developer tools reveal a 403 error when trying to access *
> /plugin_wiki/jqgrid*
>
>
> 1. GET
>
> http://127.0.0.1:8000/myapp/plugin_wiki/jqgrid?columns=server_id%2Cserver_name%2Chpsa_server_id%2Cmesh_id%2Ccustomer_id%2Cfacility_id%2Cactive%2Cmodified_date&fieldname=&fieldvalue=None&tablename=server&_search=false&nd=1348494780601&rows=10&page=1&sidx=&sord=asc<http://127.0.0.1:8000/m3t/plugin_wiki/jqgrid?columns=server_id%2Cserver_name%2Chpsa_server_id%2Cmesh_id%2Ccustomer_id%2Cfacility_id%2Cactive%2Cmodified_date&fieldname=&fieldvalue=None&tablename=server&_search=false&nd=1348494780601&rows=10&page=1&sidx=&sord=asc>404
> (NOT FOUND)
> jquery.js:2 <http://127.0.0.1:8000/m3t/static/js/jquery.js>
>
>
> I've tried on a couple of different web2py installations and see the same
> result. Looks line something is missing from the latest plugin source?
>
> Thanks in advance.
>
> Ciao,
> Dominic.
>
>
--
