Hello ... I need retrieve all contacts from one account
I do this and don´t work
I need help please
public List CargarUsuarios(Guid queCuenta)
{
using (OrganizationService service = new OrganizationService("NubitCrmNav"))
{
//Microsoft.Xrm.Sdk.EntityReference accountId = new Microsoft.Xrm.Sdk.EntityReference("account", queCuenta);
QueryExpression query = new QueryExpression("contact");
query.ColumnSet.AddColumns("contactid", "fullname","accountid");
string strGuid = queCuenta.ToString();
Guid gEmpresa = Guid.Parse(strGuid);
ConditionExpression empresa = new ConditionExpression();
empresa.AttributeName = "accountid"; // "accountid";
empresa.Operator = ConditionOperator.Equal;
empresa.Values.Add(gEmpresa);
query.LinkEntities.Add(new LinkEntity("contact", "account", "accountid", "accountid", JoinOperator.LeftOuter));
query.LinkEntities[0].Columns.AddColumns("accountid");
query.LinkEntities[0].EntityAlias = "empresa";
/*query.LinkEntities.Add(new LinkEntity("account", "contact", "contactid", "contactid", JoinOperator.LeftOuter));
query.LinkEntities[1].Columns.AddColumns("fullname", "contactid", "accountid");
query.LinkEntities[1].EntityAlias = "contacto";*/
query.Orders.Add(new OrderExpression("fullname", OrderType.Ascending));
query.Distinct = true;
List usuarios = new List();
System.Net.ServicePointManager.SecurityProtocol = tls12;
EntityCollection usuariosRecord = service.RetrieveMultiple(query);
if (usuariosRecord != null && usuariosRecord.Entities.Count > 0)
{
ContactEntityModels usuariosModel;
for (int i = 0; i < usuariosRecord.Entities.Count; i )
{
usuariosModel = new ContactEntityModels();
if (usuariosRecord[i].Contains("contactid") && usuariosRecord[i]["contactid"] != null)
usuariosModel.ContactID = (Guid)(usuariosRecord[i]["contactid"]);
if (usuariosRecord[i].Contains("accountid") && usuariosRecord[i]["accountid"] != null)
usuariosModel.AccountID = (Guid)((AliasedValue)usuariosRecord[i]["empresa.accountid"]).Value;
if (usuariosRecord[i].Contains("fullname") && usuariosRecord[i]["fullname"] != null)
usuariosModel.NombreCompleto = usuariosRecord[i]["fullname"].ToString();
usuarios.Add(usuariosModel);
}
}
return usuarios;
}
}
Account no filter
