I want to get a ProductCollection based on the value of grandchild values.

Using the code below, I can look up child values:

ProductCollection product = new ProductCollection(); RelationCollection relations = new RelationCollection(); relations.Add(ProductEntity.Relations.ProductTypeOptionAttributeCombinationEntityUsingProductId);

IPredicateExpression filter = new PredicateExpression(); filter.Add(_Child Field Value_);

product.GetMulti(filter, 0, null, relations);

But what do I do if I want to filter on a child of the ProductTypeOptionAttributeCombinationEntity?

Many thanks

Darren

P.S. Yeah I know I need to re-consider the name of that table and make it shorter!!!

Hi Darren,

You should add the Child <- GrandChild relation to the relation collection. After that you can add filter expressions based on GrandChild's fields.

example:

ProductCollection product = new ProductCollection();
RelationCollection relations = new RelationCollection();
// child
relations.Add(ProductEntity.Relations.ProductTypeOptionAttributeCombinationEntityUsingProductId);
// grandchild
relations.Add(ProductTypeOptionAttributeCombinationEntity.Relations.GrandChildEntityUsingSomeConnectionFieldId);

IPredicateExpression filter = new PredicateExpression();
filter.Add(Child Field Value);
filter.Add(GrandChild Field Value);

Regards,

Brilliant - thanks very much

Got it working.