How Can I Join On Two Columns with a LinkEntity in CRM 2011? -
i using link entity join 2 entities:
linkentity pricelevelentity = new linkentity(); pricelevelentity.joinoperator = joinoperator.inner; pricelevelentity.linkfromentityname = "product"; pricelevelentity.linkfromattributename = "productid"; pricelevelentity.linktoentityname = "productpricelevel"; pricelevelentity.linktoattributename = "productid"; query.linkentities.add(pricelevelentity); the above joining product , productpricelevel on productid attribute. want add join product.uomid on productpricelevel.defaultuomid
how can this?
if attempting return column linked/joined entity able perform additional filtering on client side, linkentity has column property should use, example:
new queryexpression("product") { columnset = new columnset("oumid"), linkentities = { new linkentity("product", "productpricelevel", "productid", "productid", joinoperator.inner) { columns = new columnset("defaultuomid") } } };
Comments
Post a Comment