Checkedlist Filter showing extra BLANK/EMPTY option

[aoverton07Participant]

I have a checkedlist filter on my grid and everything is working like it should be except for one little thing:

My drop down for the checkedlist filter is showing an extra option, and that extra option is blank….example:

In my Grid I only have 5 rows of data, for the column Im filtering two of the rows have the value of “OPEN” and three of the rows have a the value of “CLOSED” so I would expect my drop down to look something like:

Select Filter
———————-
[ ] (Select All)

[ ] CLOSED

[ ] OPEN

yet I am seeing this:

Select Filter
———————-
[ ] (Select All)

[ ]

[ ] CLOSED

[ ] OPEN

When i check the box for that empty option it does not return any rows (so technically it filters correctly) but why am I seeing this extra blank/empty option???

[Peter StoevKeymaster]

Hi aoverton07,

Blank option is displayed when you have a Blank cell in your column as the CheckedList Filter’s data source is built from your column cell values.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[aoverton07Participant]

Peter,

After inspecting the html on my page I’ve noticed that my grid creates 43 rows, despite the fact that I only have 5 rows of data. There are no gridlines for the extra rows so it looks like they are not there. Are these extra rows created because the height of my grid is taller than the 5 rows of data?

[Peter StoevKeymaster]

Hi aoverton07,

The Grid creates UI Rows depending on the Grid’s Height. It does not matter whether you have 5 or 5000 rows of data.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Shankar93Participant]

Hi Peter,

Is there any way to remove the extra blank option in the filter, mentioned in the above discussion.?

[Peter StoevKeymaster]

Hi Shankar93,

Blank is displayed when you have empty/null value in the column. Otherwise, you cannot filter these cells. If you wish, you can set the column’s filteritems property in order to override the built-in list items.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Shankar93Participant]

Thanks Peter for the quick response. Yes I was able to manipulate the column’s filteritems according to my needs.

[Author]

Posts