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 to other views.
Many thanks.
Ciao,
Dominic.
On Monday, 24 September 2012 19:54:08 UTC+2, Massimo Di Pierro wrote:
>
> :-)
>
> 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.
>>
>>
--
