Custom Filtering on RadGridView

1 Answer 26 Views
GridView
John
Top achievements
Rank 1
John asked on 24 Mar 2022, 04:18 PM

Hello,

We're trying to create a data paging system using the RadGridView, and are having difficulty with the filtering.
Here's the scenario. 

First, we set up the filtering mode = Filter row.

When a filter is applied, we intercept the Colum info that's being filtered in the "Grid_Filtering" event to create our Filtering information to pass back to the web services to get data.  

The issues is that the grid filters (Let's say it reduces the rows to 3), then as we call our web service to get data from the back end, which may have 10 items in the dataset.

My question is;  Are there any examples where one can gather the filter information, then prevent the internal grid from filtering, then applying our new data set?

We've cobbled it together, but it looks bad having the grid display one data set, only to have it clear out and load another.
What we're trying to do is pull the pages via webservice instead of loading the entire dataset into memory.

1 Answer, 1 is accepted

Sort by
0
Dilyan Traykov
Telerik team
answered on 28 Mar 2022, 08:38 AM

Hello John,

I believe you can use RadDataServiceDataSource as it can be used to perform data operations (such as filtering) directly on the server.

We do have an example in our SDK Samples Browser about how to consume a OData 4 service using it. The source code is also available in our GitHub repository.

If a similar approach does not work for you, please share your current implementation so that I can suggest potential improvements or alternatives.

Regards,
Dilyan Traykov
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/.

Tags
GridView
Asked by
John
Top achievements
Rank 1
Answers by
Dilyan Traykov
Telerik team
Share this question
or