Column.Search filtering empty columns
Column.Search filtering empty columns
Hi All,
I have a data set that contains either a tick or nothing. When using the select-filter it creates the tick option and a show all option but does not give an option for viewing non tick records only.
I added an option to the select for empty records but when performing a search with either of these
column.search("");
column.search('');
column.search('^$',true,false);
I do not get just the non ticked records, instead I get the same effect as doing a select all.
i have even tried the following to ensure it was not a space within the column
column.search(" ");
Any ideas, I cannot see why this will not filter correctly.
Cheers
Mark
Answers
Hi All,
corrected it in the end.
using the regex was the correct way. I forgot to add the draw() on the end.
final code was
column.search('^$',true,false).draw();
Cheers
Mark