Not all unique column items show up in filter popup.

[Kevin Tran]

HI support,

 My grid has almost 5000 unique records, But only some distinct values are showing in filtering drop down, I read this thread

http://www.telerik.com/community/forums/wpf/gridview/not-all-unique-column-items-show-up-in-filter-popup.aspx..

But my data comes from WCF as xml, I am parsing it to list in .xaml.cs,Can you tell me how can i increase the limit.Problem is only for one column, I am using sp1 2010.Any ideas.

P.S:It should not increase load time of page, as it already annoying users with 60 sec load time.

Any help?

[Milan]

Hello Kevin Tran,

By default, RadGridView will only show the first 1000 distinct values. This done for performance reasons but you can easily change that behavior by using the DistincsValuesLoading event:

// subscribe for DistincValuesLoadingEvent
void playersGrid_DistinctValuesLoading(object sender, GridViewDistinctValuesLoadingEventArgs e)
{
    // load all distinct values
    e.ItemsSource = this.playersGrid.GetDistinctValues(e.Column, false, null);
}

More information about GetDistinctValues can be found here.

Best wishes,
Milan
the Telerik team