This is a migrated thread and some comments may be shown as answers.

Not all unique column items show up in filter popup.

1 Answer 83 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Kevin Tran
Top achievements
Rank 1
Kevin Tran asked on 29 Jun 2010, 11:45 AM
HI support,

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


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?

1 Answer, 1 is accepted

Sort by
0
Accepted
Milan
Telerik team
answered on 29 Jun 2010, 12:57 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
GridView
Asked by
Kevin Tran
Top achievements
Rank 1
Answers by
Milan
Telerik team
Share this question
or