Hi,
I want to reproduce the following in llblgen for a PredicateExpression:
SELECT table1.* FROM dbo.ProductSpecificationAttributeMapping AS table1 JOIN dbo.ProductSpecificationAttributeMapping AS table2
ON table1.ProductID = table2.ProductID
WHERE table1.SpecificationAttributeOptionID = 1 AND table2.SpecificationAttributeOptionID = 34
I have a product entity and a mapping table with specificAttribute for a product. I want to make a filter for all product that have let says option 1 and 34.
Here's want I have so far :
rpb.Relations.Add(ProductEntity.Relations.ProductSpecificationAttributeMappingEntityUsingProductId);
rpb.Relations.Add(ProductSpecificationAttributeMappingEntity.Relations.SpecificationAttributeOptionEntityUsingSpecificationAttributeOptionId, "SpecificationAttribute1");
rpb.Relations.Add(ProductSpecificationAttributeMappingEntity.Relations.SpecificationAttributeOptionEntityUsingSpecificationAttributeOptionId, "SpecificationAttribute2");
...
...
...
string[] ids = textPrompt.Split('-');
PredicateExpression.AddWithAnd((SpecificationAttributeOptionFields.SpecificationAttributeOptionId.SetObjectAlias("SpecificationAttribute1") == ids[0]) & (SpecificationAttributeOptionFields.SpecificationAttributeOptionId.SetObjectAlias("SpecificationAttribute2") == ids[1]));
Thanks
Martin
