How to override Select all filtering with customer event

[Pradeep]

Hi,

I want to override the select all filtering in radgridview to avoid stack over flow exception as mentioned below 

https://docs.telerik.com/devtools/wpf/controls/radgridview/filtering/faq/stackoverflow-exception

https://docs.telerik.com/devtools/wpf/controls/radgridview/filtering/how-to/howto-display-all-distinct-values

 

Is there a way I can create custom list and change the item source? 

[Vladimir Stoyanov]

Hello Pradeep,

The way to avoid the exception described in this thread: StackOverflowException on selecting all distinct values is to use the approach demonstrated in Example 2 of the Display All Distinct Values article of handling the DistinctValuesLoading event of the RadGridView and setting the ItemsSource of the event arguments to a smaller number of items. Note, that the distinct values that you assign to the ItemsSource property of the event arguments should always be of the same type as the data displayed in the column. 

I hope you find this helpful.

Regards,
Vladimir Stoyanov
Progress Telerik

[Pradeep]

We want to consider all values for filtering. And not just show first 1k or 100 items. I got around the problem by using following properties: 

 

OptimizeDistinctFilterQuery: Set to true for columns that have huge distinct values.

IsFilteringDeferred: Set to true for columns that have huge distinct values.

 

Using these two properties I am able to avoid that error. Though the actual filtering itself takes long time now. But this is without the exception. 

 

In case there is another way or if this is fixed in future versions do let me know. We are currently using 2019.2.510.45 Telerik UI for WPF

[Vladimir Stoyanov]

Hello Pradeep,

Thank you for the update. 

Using OptimizeDistinctFilterQuery property along with the IsFilteringDeferred property is a viable way to improve the scenario with a large number of distinct values. 

That said, there isn't another way to avoid the stackoverflow exception described in the article referenced in my previous reply, since it is thrown by the .NET Framework.

Regards,
Vladimir Stoyanov
Progress Telerik