Changes between Version 27 and Version 28 of ServerSidePagination

Timestamp:

01/20/10 05:40:54 (15 years ago)

Author:

Fran Boon

Comment:

--

ServerSidePagination

@@ -42 +42 @@
 {{{
 {
-"rEcho": 1,
+"sEcho": 1,
 "aaData": [
     [row1.id, row1.field2, ...],
@@ -55 +55 @@
 {{{
 def callback():
-    print request.vars
+    iDisplayStart = int(request.vars.iDisplayStart)
+    iDisplayLength = int(request.vars.iDisplayLength)
     from gluon.serializers import json
-    query = ....
-    rows = db(query).select() #<<<
-    r=dict(rEcho=1,
-           iTotalRecords=len(rows),
-           iTotalDisplayRecords=len(rows),
-           aaData=[[row.field1,row.field2] for row in rows])
+    _table = '%s_%s' % (request.controller, request.function)
+    table = db[_table]
+    query = (table.id > 0)
+    rows = db(query).select(limitby = (iDisplayStart, iDisplayStart + iDisplayLength))
+    r = dict(sEcho = 1,
+           iTotalRecords = len(rows),
+           iTotalDisplayRecords = len(rows),
+           aaData = [[row[f] for f in table.fields if table[f].readable] for row in rows])
     return json(r)
 }}}
-If you print request.vars you can easy figure out what paramers are being passed and change the <<< line accordingly.
+
 === JSON Back-end implementation ===
  * Support already present in {{{modules\s3xrc.py}}}