Search

file to set appropriate defaults. In the case of

file to set appropriate defaults. In the case of

file to set appropriate defaults. In the case of

file to set appropriate defaults. In the case of

file to set appropriate defaults. In the case of

function (settings, opts) { // Define defaults let options = Object.assign({ option1:

looks for DT_RowId by default). Additionally, the

type">searchPanes.viewTotal are false by default.

true, which is the default.

This shows how to stop the clear buttons being displayed by setting the searchPanes.clear config option to be false. searchPanes.clear is true by default.

I found a work around that worked for us. I just reused the column.search() function once the table was ready. Hope this helps var lastCat = 'the category'; var table = $('#Products').DataTable({ "iDisplayLength": 40, initComplete: function () { this.api().columns('3').every( function () { var column = this; var select = $('<select><option value="">All Categories</option></select>') .appendTo( $(column.footer()).empty() ) .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 ) { if(lastCat === d) { select.append( '<option SELECTED value="'+d+'">'+d+'</option>' ) } else { select.append( '<option value="'+d+'">'+d+'</option>' ) } } ); $(table).ready(function() { column.search( lastCat ? '^'+lastCat+'$' : '', true, false ).draw(); }); } ); } });

Hi, Very happy to take a look at the issue i you can link me to a page showing the issue please. Allan

any one help me pls

Good to hear you've got it working - thanks for posting back! Allan

In this rendered code: var oTable = $('#naps').DataTable(); var myFilter = "Gaz96"; var myFilter = Gaz96; oTable.fnfilter("Gaz96"); there are two issues: Remove line 3 - it is not valid Javascript Use oTable.search( myFilter ); the legacy fnFilter method is not available if you use the $().DataTable() form. Allan

Yeah sorry. I can't legally show you the site :( Thanks anyway

I think you should be getting a Javascript error shown in your browser's error console. You most certainly should if you use $.fn.tbl.moment. It doesn't appear that the Moment plug-in for DataTables is being included on your page. I would suggest you use: $.fn.dataTable.moment("YYYY-MMM-DD"); $(document).ready( function () { $("#SearchResultsDataTable").DataTable(); }); Selecting the element outside of the document ready function don't seem to make much sense to me - you'd be as well not having the document ready function at all. Allan

Found : field type 'hidden'. Please update docs.

Can you link to a page showing the issue - per the forum rules please. The above code should result in the initial table display being shown with the same order as what was given in the aaData option (data in the new options name). Allan

Thank you!