FilterDescriptor on related entity

11-05-2009 10:16 AM |

Hi everybody.

 I have been searching for a while and tried different approaches but have been unable to use filterdescriptor on related entities.

I have a Customer Entity with a 1:n relationship with with another table called CustomerExtra which then has a n:1 relationship with a table called CustomerBusinessLine (im stuck with this design for now).

 Now my problem is that i want to filter Customers based on the CustomerBusinessLine.BusinessLineDescription (varchar(50)) field and can't figure out how.

 So my first question is: is it possible to filter like this using FilterDescriptor?

I have been trying different Paths but it just won't work and since i couldnt find a single example of it being done (at least not the way i thought it would be done) i figured im on the wrong path.

 My second question is, if it cant be done is there another recommended way of approaching this?

 Thankful for any help.

 Regards: Jonas

(was hoping something like this would work:)

<riadata:FilterDescriptor PropertyPath="CustomerExtra.CustomerBusinessLine.BusinessLineDescription" Operator="IsEqualTo" >