Server-Side Pagination

Currently we do all pagination client-side which won't be possible to keep doing as we accumulate more data

• ​http://datatables.net/examples/data_sources/server_side.html

This will be needed for:

• Request Management System
• Organisation Registry
• Volunteer Registry

fractalis has offered to look at this

Will need to patch into the models\01_RESTlike_Controller.

We already have options to filter the results within a busy REST controller, so could do something like:

if request.vars.page and request.vars.pagesize:
    start = (request.vars.page - 1) * request.vars.pagesize
    stop = request.vars.page * request.vars.pagesize
    response.s3.filter = (db['%s_%s' % (module, resource)].id > 0).select(limitby=(start, stop))

Maybe look at the currently-unused modules/webgrid.py.

pagenav in models\01_RESTlike_Controller seems unused currently...was an older implementation of a webgrid...can probably be removed.

---

Haiti