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. --
