Not all unique column items show up in filter popup.

[Chris Andrews]

Hello All,

I am sure this was answered already, but I cannot seem to find it using any of my searches.

We have a RadGridView with quite a bit of data.  We are filtering on a column, but all of the unique values in that column do not show up in the filter list to select them.  The list seems to just stop and not display anything else after a certain point.

Is there a limitation on the number of items that appear in this list?  If so, what is the count and how can we turn off this list if the count is greater than the max.  (using a style preferably).

We are using Q1 2010 SP2 of the controls.

Thanks in advance,
Chris

[Vlad]

Hello Chris,

 The grid will limit by default distinct value to top 1000. You can handle DistinctValuesLoading event and populate desired values similar to this demo.

Regards,
Vlad
the Telerik team

[Chris Andrews]

Hello Again,

Sorry for the very long response, but I am just getting back to this as it was a low priority.  Is there any way to hide the distinct list entirely if there is going to be more than 1000 rows?  The demo app you sent me just fills the list with different results.

I'd simply like to show nothing if items will be > 1000.

Thanks Again,
Chris

[Rossen Hristov]

Hello Chris Andrews,

1. Attach to the DistinctValuesLoading event of the grid.
2. Call RadGridView's method GetDistinctValues by passing the column. There is an overload in which you can specify the maximum number of values to return. The overload without this parameter will return 1000 at most by default.
3. So after you call the GetDistinctValues method, if it returns 1000 or more, then simply assign null or Enumerable.Empty to the ItemsSource property of the event arguments. If it returns less than 1000 then assign the result to the ItemsSource property of the event arguments.

This should do it.

Kind regards,
Ross
the Telerik team

[Chris Andrews]

Thanks Ross,

This gave us the bahavior we were looking for.