datatable and jqgrid are different.
datatable fetches all records at once (without ajax) that allows
arbitrary queries but does not work with large datasets.
jqgrid fetches records via ajax. that allows only simple queries
(because they have to be passed in a safe way via ajax) but works well
with large datasets.
if you do
plugin_wiki.widget('jqgrid',table='mytable',fieldname='myfield',fieldname='123')
this corrsponds to db(mytable.myfield=='123').select()
On Aug 26, 2:04 pm, Johann Spies <johann.sp...@gmail.com> wrote:
> With the datatable plugin I can use
>
> teachers=plugin_datatable(db(db.teacher.id>0).select(),_class='datatable')
> which works but is to wide and with column headers that looks ugly.
>
> db.teacher.id.represent = lambda id:
> SPAN(A('edit',_href=URL(r=request,c='default',f='edit_teacher',args=id)))
>
> works with datatable but not with jqgrid and with plugin_wiki no data appears.
>
> Regards
> Johann
>
> --
> "Be not deceived; God is not mocked: for whatsoever a
> man soweth, that shall he also reap."
> Galatians 6:7
