Calling FireCommandEvent to remove filtering on multiple columns

[Mohan]

Hi,

I have country and city column in the radgrid and I have defined a template filters using radcombobox for both the columns. I am able to filter on both columns.

The only problem I have is when removing filtering.

Say I have filtered on both Country and city column and then I select All in the Country Filter column. 

In the country combo selectedindexchanged event I am clearing the filtering using the following command

filterItem.FireCommandEvent("Filter", new Pair("NoFilter", "Country"));

The problem is that the filtering on the city column is still active. So i modified the above code to this

filterItem.FireCommandEvent("Filter", new Pair("NoFilter", "Country"));
filterItem.FireCommandEvent("Filter", new Pair("NoFilter", "City"));

THe above code does not work. The FireCommandEvent works only for the first line, not for the second. I tried switching the statement order.  Is it possible to remove filtering on multiple columns by calling FireCommandEvent multiple times.

Thanks

[Sebastian]

Hello Mohan,

More straight-forward approach would be to clear the FilterExpression of the grid and iterate through the grid columns to set their CurrentFilterValue to an empty string. See the implementation of the btnShowAll's OnClick server handler on this demo for more details.

Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Mark]

would this work if you filter for both City and Country as the same time?  Or will the last command overwrite all previous filters?

filterItem.FireCommandEvent("Filter", new Pair("Contains", "Country"));
filterItem.FireCommandEvent("Filter", new Pair("Contains", "City"));

Thanks

Mark

[Pavlina]

Hi Mark,

Indeed FireCommandEvent will fire for only one column in your case. In order to achieve the desired functionality you could try building custom filter expression which filters by two data fields.
All filter function you could find in the following online documentation article:
http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html

Regards,
Pavlina
the Telerik team