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();
I had this problem, I found because I had copied the CDN script to my local machine it wasn’t referencing the images correctly anymore as @Matt2012 pointed out. So my solution was to updated the CSS file to look for those images where I want to put them, after I saved them also. See this … Read more
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
This will give you exact result for a column. table.column(i) .search(“^” + $(this).val() + “$”, true, false, true) .draw(); ie . search( input , regex, smart , caseInsen )
“drawCallback”: function ( settings ) { var api = this.api(),data; var rows = api.rows( {page:’current’} ).nodes(); var last=null; // Remove the formatting to get integer data for summation var intVal = function ( i ) { return typeof i === ‘string’ ? i.replace(/[\$,]/g, ”)*1 : typeof i === ‘number’ ? i : 0; }; total=new … Read more
I wrote a simple example that should illustrate the idea. Start by writing a generic handler for handling data on the server side (Data.ashx but this could be a web page, web service, anything server side script capable of returning JSON formated data): public class Data : IHttpHandler { public void ProcessRequest(HttpContext context) { // … Read more
SOLUTION #1 This is the most confusing part with using Bootstrap style for jQuery DataTables and it’s undocumented so far. Bootstrap extension overrides default dom which can be confirmed by viewing its source code. You have to use specially crafted dom option similar to shown below: dom: “<‘row'<‘col-sm-3’l><‘col-sm-6 text-center’B><‘col-sm-3’f>>” + “<‘row'<‘col-sm-12’tr>>” + “<‘row'<‘col-sm-5’i><‘col-sm-7’p>>”, You can … Read more