Search

var table = new DataTable('#example table', { scrollY: 300, 'dom': 'tr', order: [[2, 'desc']], columnDefs: [ { orderable: false, targets: 0 }, {

new DataTable('#example', { columnControl: [ { target: 'tfoot', content: ['search'] } ], columnDefs: [{ target: 0, columnControl: [ { target: 'tfoot',

$('#example tfoot th:first-child span.dtcc').remove();

$('#example').DataTable().state();

var table = new DataTable('#example', { stateSave: true, stateSaveParams: function(settings, data) { // Keep only length (entries per page); remove all other state Object.keys(data).forEac

new DataTable('#example', { columnControl: ['order', ['search', 'searchList']], ordering: { indicators: false, handler: false }, stateSave: true });

$('#example').DataTable().state();

$('#example').DataTable().rows().deselect();

Do you have the raw SQL for what you want? If so, can you show me that?

DataTable.defaults.columnTitleTag = 'div'; new DataTable('#example');

$("#example").DataTable({ columns: [...], columnControl: [ "order", [ 'searchClear', { 'search' } ] ], serverSide: true, ajax: { url: '/ajax/data', contentType:

new DataTable('#example', { ajax: '../php/staff.php', columns: [ { data: null, render: (data) => data.first_name + ' ' + data.last_name },

I added columns.title to populate the header after the $('#example').empty(); statement.

var table = $('#example').DataTable(); // Initialize your DataTable

var table = $('#example').DataTable(); // Initialize your DataTable DataTable('#example', { createdRow: function(row, data, dataIndex) { // Assign a sequential ID starting from 1

DataTable('#example', {

$('#example tbody tr').removeClass('red-odd'); $('#example tbody tr td:nth-child(odd)').addClass('red-odd'); }

drawCallback: function () { $('#example tbody tr').removeClass('odd'); $('#example tbody tr:even').addClass('red-odd'); }

$('#update-class').on('click', function () { $('#example tbody tr').removeClass('odd'); $('#example tbody tr:odd').addClass('my-odd') });

$('#example tbody tr').removeClass('odd');