[Solved] A couple of issues with RadGridView Column Filtering.

[Kedar]

Hi ,

We use Telerik RadControls for Silverlight Q3 2010 (The latest service release released in November 2010 has been applied) with Visual Studio 2010 Pro.

I think there are a couple of issues with the column filtering functionality of RadGridView in this release:
1. When any column filter is opened by clicking the funnel icon adjacent to the column name, the number of values you can have in the multi-select listbox in this filter is capped at 1000. We have more than 1000 distinct values in this column and so we are not able to filter on the values that are left out of the listbox.
Has anybody else come across this issue? Is there any way for us to get more than 1000 values in the listbox in the filter? Or Telerik will need to fix this issue by code change in the component itself? Telerik support guys, can you please take a look?

2. We have Horizontal Scrollbar enabled. If we go to a column that is not visible in the grid initially (i.e. by scrolling towards right), and then apply a column filter to that column, we cannot select more than one value in the multi-select listbox in the filter. What happens is: As soon as we select a value in the listbox, the grid data refreshes and the scrollbar goes all the way to the left. As the scrollbar moves, the focus on the custom filter is lost and the filter closes. So, if we want to filter on more than one values in the multi-select, we have to each time seek out the column -> open the filter -> select another value.
Although, if the filter is applied to any column to which you DO NOT have to scroll i.e. first few columns in the grid, the filter behavior is as expected. That is, the filter window stays open till you select all of the values and click out of the filter window area.
We would like to have the grid NOT to scroll all the way to the left after each filter value is selected so that we can select as many values as we want without having to open the filter again.
Is it possible to do by any code changes at our side? Or Telerik will need to fix this issue by code change in the component itself? Telerik support guys, can you please take a look?

I have a sample that demonstrates these issues but I was not able to attach the zip file with this post. Is there any way for me to attach the zip file with the post?

Thanks in advance for any help we can get on this.

Thanks,
Kedar

 

 

 

[Rossen Hristov]

Hi Kedar,

1. You can control the number of distinct values shown by attaching to the DistinctValuesLoading event of the grid. In the event handler, you need to assign e.ItemsSource with the list of distinct values. Call RadGridView's method GetDistinctValues by passing the column from the event arguments. There is an overload in which you can specify the maximum number of values to return. If you pass in null for the maximum amount of values you will get all of them. Then assign the result to e.ItemsSource.

2. We believe that this issue was fixed with the 2010 Q3 SP1 version. Can you upgrade to it and see whether it will be gone.

I hope this helps.

Greetings,
Ross
the Telerik team

[Kedar]

Hi Ross,

Thanks for the prompt reply. We have tried your solutions for both of the issues I had mentioned and the solutions worked perfectly.

Thanks,
Kedar