clearfilters with asp.net webservice

[onefortypoint6Participant]

Hi, in case anyone is doing this, if you are trying to apply a filter to the grid via an asp.net web service, the clearfilters method will prevent you adding a new filter. The work around is to loop through any filters set, and remove them 1 at a time.

For example:
(this doesnt’ work, it clears all filters, even the new one you added)

 var applySearchButtonsFilter = function (buttonName) {

                $("#jqxgrid").jqxGrid('clearfilters');

…then addfilter code here
}

(this does work, manually removing the filters)

var applySearchButtonsFilter = function (buttonName) {

                //$("#jqxgrid").jqxGrid('clearfilters');

                var filtersinfo = $('#jqxgrid').jqxGrid('getfilterinformation');

                $.each(filtersinfo,

                    function (filter,filtercolumn,filtercolumntext) {

                        $('#jqxgrid').jqxGrid('removefilter', filtercolumn.filtercolumn);

                    }

                );

...then addfilter code here

}

[onefortypoint6Participant]

var removeAllFilters = function () {
                var filtersinfo = $('#jqxgrid').jqxGrid('getfilterinformation');
                $.each(filtersinfo,
                    function (filter, filtercolumn, filtercolumntext) {
                        $('#jqxgrid').jqxGrid('removefilter', filtercolumn.filtercolumn);
                    }
                );
            }

[Peter StoevKeymaster]

Hi onefortypoint6,

The “clearfilters” method removes all filters and works as expected. You can use it and add filters after that, too. A demonstration is available online – filtering.htm.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[onefortypoint6Participant]

Hi Peter, when I use “clearfilters” it does clear all of the filters, but when I add a new filter in the same function, the newly added filters are not passed to my web service. It’s okay, it is working great with the manual removal of entries. Love the product though, great work

[Peter StoevKeymaster]

Hi onefortypoint6,

The “clearfilters” method clears the filters and refreshes the Grid. If you do async server filtering and you try to add a new filter while the filters are cleared, I suppose that you will end with 2 async requests to your server. As it is async operation, it is possible that the “clear” operation is the last one in the stack and the request with your new filter is not taken into account. If you just want to clear the filters without refreshing the Grid, call the “clearfilters” with parameter false.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[onefortypoint6Participant]

Thanks Peter, will try the false parameter

[DMParticipant]

I hit this problem also but specifying the false parameter didn’t work. Tracing through the code I found the condition:

if (apply == true || apply != undefined) {
this.applyfilters();
}

where “apply” is the “false” argument specified in the ‘clearfilters’ call. If “apply” is false then it’s not undefined and it applies the filters anyway.

I’ve worked round the problem it by passing “undefined”. i.e.

$(‘#jqGrid’).jqxGrid(‘clearfilters’, undefined);

and then forcing a refresh on the grid data afterwards.

[Author]

Posts