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

RadGridView Filter not showing all results in grid

3 Answers 144 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 15 Jan 2019, 02:55 AM

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

3 Answers, 1 is accepted

Sort by
0
Martin Ivanov
Telerik team
answered on 17 Jan 2019, 04:14 PM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Chris
Top achievements
Rank 1
answered on 17 Jan 2019, 04:51 PM

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

 

0
Martin Ivanov
Telerik team
answered on 22 Jan 2019, 11:27 AM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
GridView
Asked by
Chris
Top achievements
Rank 1
Answers by
Martin Ivanov
Telerik team
Chris
Top achievements
Rank 1
Share this question
or