Search

also your columnDefs can be simplified to columnDefs:[{"targets":[0,1,2,4, 6,7,8], "className": "text-left"}, {"targets":[3], "className": "text-right"}, {"targets":[5], "className": "text-center"}],

serverSide": true, select: true, "columnDefs": columnDef, "bServerSide": true, "paging":

use the render option in columns or columnDefs https://datatables.net/reference/option/columns.render

Maybe this will work for you: var table = $('#example').DataTable( { "ajax": 'http://localhost/two/test/api2', "columns": [ { "data": "name" }, { "data": "adress" }, { "data": "ID" }, { "data": null, "defaultContent": "" } ], "columnDefs": [ { "targets": -1, "createdCell": function(td, cellData, rowData, row, col) { $(td).prepend( "<button>Click!</button>" ); } } ] } ); Sorry if there is syntax errors :smile: Kevin

serverSide": true, "ajax": "php/Datatable_User_zktime.php", "columnDefs": [ { "className": "dt-center", "targets": "_all",

a loop: $('table').each(function() { $(this).dataTable( { ... "columnDefs": [ { "targets": [ 2 ], "render": $.fn.dataTable.render.number(

Change serverSide to false and get all 100 records. Let DataTables manage it. dt = tableid.DataTable({ "initComplete": processTable, "destroy": true, "sDom": '<"top"lf>rt<"bottom"ip><"clear">', "columns": col, "serverSide": false, "sAjaxSource": "/App/home/loadDetails", "ordering": true, "searching": true, "columnDefs": colheader });

data numerically. For example: columnDefs: [ { targets: 0, type: 'num'

display a download link: "columnDefs": [ { "targets": 0, "data": "download_link",

4th) column: $('#category_table').DataTable({ // ...skipped... columnDefs: [ { targets: 3, // 4th column,