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

What exactly is wrong with your code? Also, your sql have 1 join with the same table (self join) but you are adding 3 relations.

(Edit) Example: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=10359&StartAtMessage=0&#57706