[Solved] Filteriing: How can I increase the number of items displayed in the control?

[Michael Maddux]

Hello!

When our users click the filter icon on a grid view, they are not always shown choices for all of the rows in the grid.  There seems to be a limit of 1000 items displayed, so it becomes a problem when there are more than 1000 rows in the grid..  The users would like to be able to access ALL of the items for that column.  Is this possible?

Thanks,

Mike Maddux

[Vlad]

Hello,

 You can use DistinctValuesLoading event to assign desired values. Please check this blog post for more info. 

All the best,
Vlad
the Telerik team

[Michael Maddux]

Thanks very much for your very quick response!

I was hoping that there would simply be a way of telling the grid to increase the maximum number of values in the filter display.  There isn't? 

I don't have any special values that I want to display - just all of the distinct values in the column.  It seems to me that the grid should be able to take care of this.  After all, it does this very well as long as the number of distinct values is not greater than 1000.  Why should it stop at 1000?

I tried using the example in the blog post that you refer to.  When I use AddRange on the ItemsSource parameter, the ItemsSource ends up with 1782 distinct values.  This is the correct value for the column that I am addressing.

The only problem is that the filter control still only displays 1000 values, so I'm right back where i started - no change in behavior.  The user doesn't see all of the values that are in the column.

Thanks,

Mike

[Vlad]

Hello,

I've attached an example project to illustrate you how to achieve your goal. 

Regards,
Vlad
the Telerik team

[Michael Maddux]

That worked...thanks!