RadGridView Filter not showing all results in grid

[Chris]

Hello,

We have a RadGridView that has 150,000 rows (and so is using the default UI virtualization) as well as default column filters available on each column. When we check one of the "distinct values" checkboxes on the Name column, the resulting grid displays only entries for the selected name as expected -- however, it doesn't display all the results that were in the 150,000 rows. It's hard to tell how it is deciding where to cut off the results, but since each row has a time stamp we can see that it takes the top rows up until a certain point and then stops. So for one case, 69 rows were displayed when there were 624 rows in total for that selected name.

I've searched around quite a bit but couldn't find this exact scenario addressed -- do you have ideas/suggestions for this problem?

Thanks,

Chris

[Martin Ivanov]

Hello Chris,

The distinct values filter is limited to 1000 entries by default. You can see how ti change this in the Display All Distinct Values article. Can you try this and let me know if it helps? 

Regards,
Martin Ivanov
Progress Telerik

[Chris]

Hello Martin,

Unfortunately I'm not referring to the Distinct Values Filter. What I'm referring to is the actual rows in the RadGridView that are displayed after selecting a distinct value filter. So in my example, sometimes I may have 10,240 rows in the RadGridView that have the name "Test 123", but after selecting "Test 123" from the Name column's distinct value filter, the RadGridView shows only 4,372 rows.

So for some reason I don't get all the results back from the filter. When we filter our results at the query level however, we then get all 10,240 rows to display in the RadGridView. Does that make sense? We're trying to figure out why the column's distinct value filter doesn't show all the results in the grid.

Thanks,

Chris

 

[Martin Ivanov]

Hello Chris,

Thank you for the additional description. I think I understand what you mean now. However, I've tested this and I wasn't able to reproduce it. Can you please check the attached project and let me know if I am missing anything? To test the example use the distinct values of the "Type" column.

Regards,
Martin Ivanov
Progress Telerik