Search

This is the working code and this is how I have implemented it. Hope this helps. Yes here as well its name value pair. Probably you can serialize ! just a thought [code] oTable = $("#Remittance").dataTable( { "sDom": "<'row'<'row'<'span6'l><'span6'f>r>t<'row'<'span6'i><'span6 'p>>", "sPaginationType": "bootstrap", "bSort": false, "bInfo": true, "bProcessing": false, "bAutoWidth": true, "bServerSide": true, "bRetrieve": true, "bDeferRender": true, // Make the first 'id' column invisible for the end user "aoColumns": [ { "bVisible": false }, null,null, null, null, null, null, null, // Script location "sAjaxSource": "../includes/getRemittance.php", "sServerMethod": "POST", "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) { aoData.push( { "name": "remitStatus", "value": remitStatus } ); oSettings.jqXHR = $.ajax( { "dataType": 'json', "type": "POST", "url": sSource, "data": aoData, "success": function (data) { $('#Remittance').removeClass('hide invisible'); $('#processing').removeClass('alert alert-info').addClass('hide invisible'); fnCallback(data); }, statusCode: { 200: function(data) { if (data['iTotalDisplayRecords'] == 0 ) { $('#processing').removeClass('alert alert-info').addClass('hide invisible'); } } } } ); } }); [/code]

The fnPagingInfo plug-in ( http://datatables.net/plug-ins/api#fnPagingInfo ) is the way to do it for paging. There isn't currently an equivalent plug-in for filtering, but the data store object in DataTables is the oSearch parameter with this model: http://datatables.net/docs/DataTables/1.9.3/DataTable.models.oSearch.html - if anyone fancies creating a similar plug-in :-) Allan

:-) @Allan I am new to Ajax.... but your posts and datatables.net are much helpful to do all those analysis...

Argh! Thanks, Allan, you nailed it!

Exports as in the files created by TableTools, or something else? If TableTools, then you can use http://datatables.net/extras/tabletools/button_options#fnCellRender to manipulate the string before it is exported. Allan

I've posted my debug data if anyone could help :) Code: oveyak

It look alike you are using an old version of TableTools: TableTools 2.0.1 A new version (2.1.2) is available. TableTools 2.1 is where the nice new styling was applied :-). There is one thing to mention, TableTools 2.1.2 has a bug in it with the 'collections'. This has been fixed and is available in git, but I've not yet released the fix. I hope to do so in the next few days now that I'm happy the issue has been addressed. Regards, Allan

The link shows client-side processing rather than server-side, however the principle is the same for both. Also you don't have to use KeyTable - you could have a double click event on a cell that will bring up the Editor dialogue for that cell. Allan

Were you load the files through a web-server or file://? If the latter you need to set up a security exception for Flash to allow the movie to play sine it is running from your local file system. I'd suggest trying to get it going through a web-server. If that doesn't work, give us a link to the page. Allan

I may be wrong, but you can probably set up a timer function to call: oTable.fnDraw() at specified intervals. Something like this: $(document).ready(function(){ window.SetInterval(oTable.fnDraw, 5000); });