I noticed an issue where after selecting “null” in a column filter, then clicking our “Refresh” button – which calls: $(‘#jqxgrid’).jqxGrid(‘clearfilters’);, it appears the filter is not really cleared. Thus, when you filter on another column, the original column filter is still applied.
I have replicated this issue in this JSFiddle: http://jsfiddle.net/ttsabbott/t74mv99c/1/
Steps to reproduce:
1. Select “null” in the Product column filter
2. Click “Clear filters”
3. Enter 5 in the Quantity column filter
You will see that nothing is returned even though there are rows with Quantity = 5.
That is because the “null” filter of Product has been re-applied.
Note: I created this example based upon this JSFiddle: http://jsfiddle.net/jqwidgets/4DMBV/