Search

Thanks for the response allan. In this specific case I used two special characters... I used ! as the "not" with the column search to get empties/blanks. I also used * as a "match something" to get all not blank values. In both cases there is no need for users (in this case) to search for either of those characters by themselves. Not completely self evident, but this need had a small audience that could be trained to use that...and they were highly motivated because they needed to find empties!

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