Search for all rows having an empty cell
Search for all rows having an empty cell
Hi there,
i'm struggling to find a solution with latest version of DT.
I've a large table with rows that might contain empty values.
When these cellsare empty, they already have a css class applied on (<td class="empty">
) , as well as the row (<tr class="hasEmpty">
).
These empty cells can be in any column (except the first which always contains a value - not sure if relevant)
Then i'd like to have a button outside the table to show all rows that contain at least one cell which is empty.
Is there a way do to this?
Based on the empty value as a regExp ? ( '^$' ) Or maybe the <tr> class which is already applied ?
myTable.columns().search('^$').draw()
will return no result.
(nor myTable.columns().search('something').draw()
, although there is "something" in some cells, not sure why...)
Thanks for your help !