Hello Bruno, What do you think of using web2py service JSONRPC?
So we need function to deal with those call from DataTables : intiDisplayStartDisplay start pointintiDisplayLengthNumber of records to displayintiColumnsNumber of columns being displayed (useful for getting individual column search info)stringsSearchGlobal search fieldboolean bEscapeRegexGlobal search is regex or notbooleanbSortable_*(int)*Indicator for if a column is flagged as sortable or not on the client-sideboolean bSearchable_*(int)*Indicator for if a column is flagged as searchable or not on the client-sidestringsSearch_*(int)*Individual column filterboolean bEscapeRegex_*(int)*Individual column filter is regex or notintiSortingColsNumber of columns to sort onintiSortCol_*(int)*Column being sorted on (you will need to decode this number for your database)stringsSortDir_*(int)*Direction to be sorted - "desc" or "asc". *Note that the prefix for this variable is wrong in 1.5.x where iSortDir_(int)was used)*stringsEchoInformation for DataTables to use for rendering Here the reference : http://www.datatables.net/usage/server-side I am searching where to start to solve the server side issue of PowerTable... Richard On Tue, Feb 1, 2011 at 8:11 AM, Bruno Rocha <[email protected]> wrote: > 2011/2/1 Johann Spies <[email protected]> > > I hope some time in future people with proper knowledge of javascript like >> you will be able to combine pagination the way jqgrid from the plugin_wiki >> does (using limitby in sql-queries) with the other powerfull features to get >> the best of both sides. > > > datatables.net has a full support to JSON and Xml datasources, with that > we can do server side processing in the same way jqgrid does, I am planning > to rewrite some parts of powerTable to implement it. > > And I am counting the help of people who knows javascript and web2py, any > help, suggestion and report is very appreciated. > > Thanks > > Bruno. > >
