Dynamics Community Forum Thread Details

How get related objects with QueryExpression?

Hello

I have 2 entities: Contact and Account.

Account linked to Contact by field "parentcustomerid"

I wrote query:

(sorry I can't mark it as code, because there is a error in this forum:( )

public bool MakeDynamics365Call()
{
var query = new QueryExpression
{
EntityName = "contact",
ColumnSet = new ColumnSet(true),
Criteria = new FilterExpression
{
Conditions = {
new ConditionExpression {
AttributeName = "emailaddress1",
Operator = ConditionOperator.Equal,
Values = { "b5055354@urhen.com" }
}
}
}
};

var relationship = new Relationship();
relationship.SchemaName = "parentcustomerid";
var relatedEntity = new RelationshipQueryCollection();
relatedEntity.Add(relationship, query);

RetrieveRequest request = new RetrieveRequest();
request.RelatedEntitiesQuery = relatedEntity;
request.ColumnSet = new ColumnSet("accountid");

//real account ID
request.Target = new EntityReference { Id = Guid.Parse("cf731978-20cb-e911-a828-000d3aba5e95"), LogicalName = "account" };

var res = service.RetrieveMultiple(query);
return true;
}

As result I have: