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

Filtering on multiple datasources

2 Answers 32 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Prachi
Top achievements
Rank 1
Prachi asked on 10 Jul 2012, 05:42 AM
Hello,

I am working on a solution using odataservice implementing linq to entity.
there is a table named worksite. It has basic informstion as name, address, etc..

There is a separate table named location. It has four level of hierarchy. e.g onshore/ offshore is the parent. then it had child as area, then region and finally field.

We are saving location Id as foreign key in worksite table. We need to enable filtering on all four fields of location but the only data saved in worksite is location id and from that we can track parent and go to the fourth level.

first  query is : Is there a simple way to filter on Location name for which id is saved. by default  datafield is set to Location Id so filtering is enabled on id which is  number not on name.

second query : How can we implement filtering on other fields i.e. Location.Parent.Name, Location.Parent.Parent.Name, etc... which are not saved anywhere but evaluated at run time from value of location id.

2 Answers, 1 is accepted

Sort by
0
Accepted
Tsvetoslav
Telerik team
answered on 12 Jul 2012, 12:34 PM
Hi Prachi,

There is no way for RadGrid to filter on any data that has not been passed to it as a data-source. I am afraid you have to filter the data programmatically and then pass it to the grid.

Regards,
Tsvetoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Prachi
Top achievements
Rank 1
answered on 31 Jul 2012, 12:57 AM
Thanks for the reply.
I am filtering the data programmatically.
Tags
Grid
Asked by
Prachi
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Prachi
Top achievements
Rank 1
Share this question
or