[Solved] RadGrid DistinctFilters cancelling auto filtering

[Yvan]

Hi,
I have RadControls 2010 Q3 and I like the Excel style filtering of the RadGridView. I want to implement it with a server side filtering. The problem with the Distinct Filter fonctionality is that it automatically apply filter and a call to the server is done each time that I clicked to the filter checkbox.
It is possible to disable the auto apply filter of the distinct filter ? I want to apply filter only when the user click to the "Filter" or "Clear Filter" button.

Thanks
Yvan      

[Rossen Hristov]

Hi Yvan,

We do not support this functionality out-of-the-box.

In order to do this, you will have to develop your own custom filtering control and implement any kind of custom logic. This blog post explains how to do this.

An example of a custom filtering control that filters directly on the server can be found in this blog post. You can use it as a base and change it's UI to have distinct values in it. The distinct values can be obtained by calling RadGridView's GetDistinctValues method.

Another way to achieve this would be to turn the AutoLoad of the DomainDataSource and perform load manually when the customer has defined all filters that he wants.

By the way, with the upcoming SP1 we will release our own RadDomainDataSource, which will integrate with RadGridView, RadDataPager and RadDataFilter without a single line of code.

If you are interested I can send you an unofficial build so you can play around with it before its official release. Let me know if you want a sample app with the unofficial build.

I hope this helps.

Best wishes,
Ross
the Telerik team

[Yvan]

it is possible to add this feature in futur release of telerik RadGridView ?
Just add a boolean property "EnableAutoApplyFilter" (or something else) into the DistinctFilter object. By default this property is true.
Thanks

[Rossen Hristov]

Hi Yvan,

I have created a new Feature Request in our PITS system. Please, vote for it in order to increase its priority. The more votes it has, the sooner it will enter development.

Here you can find the PITS Issue: Public URL

Until then, your option would be to develop a custom filtering control or use the AutoLoad ability of the DomainDataSource.

I hope this helps.

Best wishes,
Ross
the Telerik team

[Yvan]

Thanks Ross