Column.Search filtering empty columns

Column.Search filtering empty columns

markblue777markblue777 Posts: 8Questions: 4Answers: 2
edited January 2016 in Free community support

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

  • markblue777markblue777 Posts: 8Questions: 4Answers: 2
    edited January 2016

    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

This discussion has been closed.