Hi Everyone

I'm trying to use GetMulti(filter) to get a list of products back from my database - and to do this I'm doing the following:

PredicateExpression filter = new PredicateExpression();

// Specify which product we would like
filter.Add(Product.ProductId == m_iProductID);

// Make sure the item is in green
filter.AddWithAnd(ProductOptionProfile.ProductOptionID == 10);

// Make sure the item is in the size XL
filter.AddWithAnd(ProductOptionProfile.ProductOptionID == 15);

// Do our 'search' for availability
ProductCollection myproduct = new ProductCollection();
myproduct.GetMulti(filter);

When I do this, I get the error back that "ProductOptionProfile.ProductOptionID" could not be bound - which I am presuming is because you have to just specify child fields of the ObjectCollection you are trying to do a GetMulti for.

So... how can i do it

Many thanks in advance!

Darren

I've been having a good read and I now think I know where I was going wrong.

I'll repost my new problem

If you are filtering on a field related to your entityCollection to retrieve, you need to add the underlying relation. Then you pass the relation collection in the GetMulti call.