[Solved] Customizing the Filter criterion of RadDataFilter.

[SivaPrasad Bevara]

Hi,

I have to display huge amount of data (millions of records) in a grid. If I take the whole data and display in the Grid, then it is a big performance issue.

So I am getting the data based on the Page index and page size from the database.

I wish to use the RadDataFilter with this Grid.
The problem is, when we use the RadDataFilter it will filter only the data that is loaded in the Grid. And in this case I am not loading the complete data into the grid.

So I am planning to collect the filter criterion from the RadDataFilter and send it to the database query.
Please guide me how (in which event) can I get the filter criterion from the rad filter and in which event of the RadDataFilter I need to send the data to the database.

Please help.

Regards,
SivaPrasad.B

[Vlad]

Hi,

 You can bind the filter to RIA services using DomainDataSource (or RadDomainDataSource) if you want filtering on the server. You can check this demo for more info:
http://demos.telerik.com/silverlight/#DataFilter/DomainDataSource
http://demos.telerik.com/silverlight/#DomainDataSource/RadDataFilterIntegration

Regards,
Vlad
the Telerik team

[SivaPrasad Bevara]

Hi Vlad,

Thank you for your quick response.

From some articles, I understand that RadDomainDataSource does the filtering at the server, on the complete data which is returned from the query.
This means that we have to get the complete data to the server first, and there it does the filtering and return the filtered data to the UI.

But in my case, I want to filter the data at the database itself as I have deal with huge amount of data. Returning the complete data to the server and filtering there will reduce the performance.

Is there any way, by which we can know the filter criterion at the server. So that I can send the filter criterion to the database query, and get only filtered data from the database.

Please help.

Regards,
SivaPrasad.B

[Vlad]

Hello,

 Actually both examples will filter directly on the server. For the regular DomainDataSource however you will need to write code - for RadDomainDataSource it is codeless. 

Greetings,
Vlad
the Telerik team