Search

Figured it out, the answer is: row.EndDate

That was exactly what i needed. Thank you!

Are you basically trying to find if a column contains some value? If so the filter() method along with count() might be the best way to do it: theTable .column(1) .data() .filter( function ( val ) { return val === searchTerm; } ) .count(); Allan

I figured it out: if (tradeSelected === "Select All") { supplierTable.columns(3).search("").draw(); newSupplierTable.columns(3).search("").draw(); } else { supplierTable.columns(3).search(tradeSelected).draw(); newSupplierTable.columns(3).search(tradeSelected).draw(); } I thought I had already tried this, but I must have had a typo somewhere. Thanks, Pat

Is there anything specific that you think would be useful for me to add to the documentation to explain it a bit more? It is slightly more convoluted than I would like that case - there will be other ways to do it, but I think that's probably one of the most efficient. Allan

Fixed here. It was a falsy problem with the 0. Allan

thanks Allan.

That worked, allan. Thanks! Here are the working relevant settings: var table = $("#dataTable").DataTable({ ... searching: true, dom: "ltip" // Remove global search box });

I solved the issue by replacing on server "datatableconvertdate" string with following function: function ( data, type, row, meta ) { return window['datatableconvertdate'].apply(null, arguments);} using above I was able to still create function expression with variable name "datatableconvertdate" rather then in my options object for datatables

Thanks for the feedback - great to hear! Super nice to hear that first thing in the morning :-) Regards, Allan