checkedlist filter: sorting of null value filter

[KristofParticipant]

Hi there,

when I am using the checkedlist filter and my data contains null values in such column the option to filter on empty values is shown in between all the other values. It seems to me that the checkedlist filter values are sorted by alphabet and the option for empty values is treated as the text ‘null’.

I can’t include screenshots here, so I will reproduce the filter values we have for some countries column:

[] Netherlands
[] Norway
[]
[] Oman
[] Poland

the empty line would be the checkbox you need to select in order to get only the rows where country is empty.

Any ideas how I can change that behaviour are highly appreciated. I would prefer to have the empty values filter at first or last position. Thats easier to explain to our users 🙂

Thanks in advance

[Peter StoevKeymaster]

Hi Kristof,

A possible solution is to manually set these items using the “filteritems” column property. However, we’ll fix the sorting by the end of the month

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[KristofParticipant]

Hi Peter,
end of the month sounds awesome to me. thank you very much!!!

Best Regards,
Kristof

[Author]

Posts