Blank cell in fiter menu

Tags: #<Tag:0x00007efc62090e38>
#1

Hi,

There are some blank data in the table cell. when I have implemented filter option, blank cell also coming in filter. How to avoid black cell in filter menu.

image

Thanks

#2

Hi @fayejitendra

You could add a condition to a specific column, and execute it.

Here is a demo - https://jsfiddle.net/za3cw1np/
As you can see when you click on filter in the third column you don’t have a (Blank cell).

#3

Thansk for your reply. But after adding this condition we are not able to show blank cell in table.

I want to show blank cell in the table but when we click on filter icon then filter dropdown should not have blank cell.

Thanks

#4

You can use beforeOnCellMouseDown hook. Here is a demo - https://jsfiddle.net/teya782x/

But this approach only works the first time. If you click on the filters and you nothing chosen this condition filtersPlugin.addCondition(coords.col, 'not_empty', []); is applied after all. On the other hand, if you choose something the Blank cells return if you will click on the filters for the second time.

So your requirement id hard to achieve. Maybe before Filter and afterFilter hooks are more appropriate.

#5