Hi,

I've looked in the documentation how to add a prefetchpath to a typedlist, but can't find it. FetchTypedList doesn't have a parameter to add a prefetchpath. Is this even possible?

Thnx.

JM

Nope, this is not possible. PrefetchPath are used with Entities not TypedLists.

Hi Walaa, thnx for the quick answer.

I have a TypedList, and i'm trying to execute the following query:

select *
From Products P

Where P.ProductID  in ( Select distinct CA.ProductID From CombinationProducts CA Where CA.CombinationID =1)

The query is much bigger, i have to use a typedlist for this, but this the basic idea.

How i am suppose to do this?

PrefetchPaths has nothing to do with this query, you should use a FieldCompareSetPredicate to implement the IN predicate. Please check the docs for the FieldCompareSetPredicate.