Unplanned
Last Updated: 03 Jan 2023 11:38 by ADMIN
Grzegorz
Created on: 30 Dec 2022 11:20
Category: GridView
Type: Bug Report
0
GridView: Column's ShowDistinctFilters still queries the underlying collection

Setting ShowDistinctFilters for a RadGridViewColumn hides the distinct values from the filter popup as expected.

But the grid still queries the ItemsSource for distinct values of said column when showing thje popup - it calls something like

MyQueryable.Select(item => item.SomeColumn).Distinct().OrderBy(item => item).Take(1000))
It looks like a (small) performance hit, especially when custom IQueryable implementation makes calls to external services to query the data.  Which is my case.
1 comment
ADMIN
Martin Ivanov
Posted on: 03 Jan 2023 11:38

Hello Grzegorz,

Thank you for the feedback. We have changed the item status accordingly. Disabling the data query seems meaningful when ShowDistinctFilters is false.

Currently, if you want to change this behavior you will need to replace the FilterControl of the column with a custom one where you can implement custom filters.

Regards,
Martin Ivanov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.