First of all, initialize DataTable only once. Then as per your question, use rowCallback and not fnRowCallBack as shown below: var oTable = $(‘#countryTable’).DataTable({ ‘rowCallback’: function(row, data, index){ if(data[3]> 11.7){ $(row).find(‘td:eq(3)’).css(‘color’, ‘red’); } if(data[2].toUpperCase() == ‘EE’){ $(row).find(‘td:eq(2)’).css(‘color’, ‘blue’); } } }); Here’s a fiddle
Maybe you are looking at something like this: http://www.datatables.net/plug-ins/api/fnFilterClear You could clear the search in a very simple way: var table = $(‘#example’).DataTable(); table .search( ” ) .columns().search( ” ) .draw();
You can define your columns in a different way like this “aoColumns”: [ null, null, null, null, null, { “mData”: null } ] or this “aoColumnDefs”:[ { “aTargets”:[5], “mData”: null } ] Here some docs Columns Take a look at this DataTables AJAX source example – null data source for a column Note that prior … Read more
Use createdRow and columns.createdCell options to define a callback function that will be called when TR and TD element are created. $(‘#example’).dataTable( { ‘createdRow’: function( row, data, dataIndex ) { $(row).attr(‘id’, ‘someID’); }, ‘columnDefs’: [ { ‘targets’: 3, ‘createdCell’: function (td, cellData, rowData, row, col) { $(td).attr(‘id’, ‘otherID’); } } ] }); See this example … Read more
For DataTables version 1.10.5 and newer, as documented on the blog post announcing the integration of HTML5 data-* attributes, the number of rows to show per page can be specified via the source (HTML) table through the data-page-length attribute: <table data-page-length=”25″> … </table> For DataTables version 1.10 and newer, as documented at Reference > Options … Read more
Basically, the two constructurs return different objects. dataTable constructor var table = $(<selector>).dataTable() dataTable is the oldschool dataTables constructur, which returns a jQuery object. This jQuery object is enriched with a set of API methods in hungarian notation format, such as fnFilter, fnDeleteRow and so on. See a complete list of API methods here. Examples … Read more