Hi,
I am trying to retrieve multiple addresses from the customer name. However, the inner join expression seems not to be working.
Am I missing anything based on the below codes?
Thanks in advance,
Young
----------------------------------------------------------------------------------------------------------------------------------------
ColumnSet cols = new ColumnSet();
cols.Attributes = new string[] { "name", "accountid"};//, "customeraddressid", "name", "line1", "line2", "city", "stateorprovince", "postalcode" };
LinkEntity innerJoinOne = new LinkEntity();
innerJoinOne.LinkFromEntityName = EntityName.account.ToString();
innerJoinOne.LinkFromAttributeName = "accountid";
innerJoinOne.LinkToEntityName = EntityName.customeraddress.ToString();
innerJoinOne.LinkToAttributeName = "parentid";
innerJoinOne.JoinOperator = JoinOperator.Inner;
ConditionExpression where = new ConditionExpression();
where.AttributeName = "name";
where.Operator = ConditionOperator.Like;
where.Values = new string[]{txtName.Text.Trim()}; // txtAccountName.Text.Trim() };
// set the properties of the filterexpression
FilterExpression filter = new FilterExpression();
filter.FilterOperator = LogicalOperator.And;
filter.Conditions = new ConditionExpression[] { where };
innerJoinOne.LinkCriteria = filter;
//// create the queryexpression object
QueryExpression query = new QueryExpression();
query.EntityName = EntityName.account.ToString();
query.LinkEntities = new LinkEntity[] { innerJoinOne };
query.ColumnSet = cols;
// Retrieve the Accounts
BusinessEntityCollection addresses = new BusinessEntityCollection();
addresses = crmService.RetrieveMultiple(query);
