Hi,

I am trying to run a search query using PredicateExpression. My search is like:

Select * from Customers innerjoin Orders on order.CustomerID = Customer.CustomerID innerjoin shipping on shipping.OrderID = order.OrderID where customer.Name= 'John' or order.orderdate ='4 Jan 2010' or shipping.shippingdate = '5 Feb 2010'.

Could someone please help me with this query.

Many thanks,

Anu

You will only need to pass the relations (joins) as specified in the example found here: Advanced Filtering

P.S. You won't need aliases as specified in the example, as you don't join to the same entity more than once.

Thank you very much.

I managed to get it working. The main problem was that I didn't add relationcollection as parameter in GetMulti()...

thanks again,

Anu