Search

documentation for the formatting options available (Moment.js documentation | Luxon).

the columns.data and columns.render options can be provided as

columns.data and / or columns.render options. Object based data may

While the basic functionality was great, we looked into advanced features like stateSave and only allowing some columns to be sortable. Here is the end result...

way, through their initialisation options. In this example we

of examples, exploring the options available for server-side processing

all of the same options as the $.ajax method,

all of the same options as the global search

way, through their initialisation options. In this example we

some of the other options to enhance your tables

Thank you!

I kind of fixed it: $(document).ready(function () { $('table.display').DataTable({ initComplete: function () { this.api().columns('.select-filter').every(function () { var column = this; var select = $('<select><option value="">Show All</option></select>') .appendTo($(column.header())) .on('change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); column .search(val ? '^' + val + '$' : '', true, false) .draw(); }); column.data().unique().sort().each(function (d, j) { var val = $('<div/>').html(d).text(); select.append('<option value="' + val + '">' + val + '</option>'); }) }); }, paging: false, sort: false, scrollY: 500, scrollX: true, fixedColumns: { leftColumns: 2 }, }); }); For the headers where I do want the filter option I added the class select-filter to it. By doing this I am able to optimize and get the result I need.

Wonderful, thank you Allan!

I've just committed the fix for this and it will be in 1.7.4 which will ship this week. Regards, Allan

You are loading the Bootstrap 3 integration code rather than the Bootstrap 4 (editor.bootstrap4) which is in part causing the issue: http://live.datatables.net/ceyavapu/4/edit . That helps, but its not perfect. There appears to be something related to table-sm causing the rest of the issue. Remove the vertical-align: top fixes it, but that isn't table-sm. I've tried it locally but it seems to work here. Going to have to dig around a bit more on this one I'm afraid! Allan

Hi @amrit_486 , Yep, you can disable buttons with the button().disable() method. You could call that in an event, such as init if static data or xhr if loading via Ajax. I'm not sure what you mean by showing the "inbuilt loader", sorry. Cheers, Colin

Thanks for the answer, kthorngren! It solved my problem... Best regards!

A forum search yields lots of results like this: https://datatables.net/forums/discussion/comment/127291/#Comment_127291 Exporting complex headers is not currently supported. Kevin

Hi mpoirier, It's not possible to set the Ajax dataSrc after initialisation. See this thread for more suggestions. Cheers, Colin

Hi Kevin !! Thanks for you post !!..