How to use filter on link entity

(0) Share

Report

Posted on by sahara

645

Hey,
I'm trying to get a product records according to linkentity filtering, I need to get all products that has Active productstatus and the linked phonecall category is fun and not open:

AKA : PRODUCT - (productstatus = Active)& (linkedphonecallcategory = fun && linkedphonecallstatus != open)

when I run my current query, the results I get are without the liked entity filter... I don't understand why.
That's my code:

QueryExpression query = new QueryExpression("product");
query.Criteria.AddCondition(new ConditionExpression("productstatus", ConditionOperator.Equal, 0));
query.ColumnSet = new ColumnSet("product");
LinkEntity phoneCallLink = new LinkEntity("product", "phonecall", "productid", "regardingobjectid", JoinOperator.LeftOuter);
FilterExpression filter1 = new FilterExpression(LogicalOperator.And);
filter1.Conditions.Add(new ConditionExpression("phonecallcategory", ConditionOperator.Equal, GetConfigByKey("fun")));
filter1.Conditions.Add(new ConditionExpression("statecode", ConditionOperator.NotEqual, 0));

phoneCallLink.LinkCriteria = filter1;

query.LinkEntities.Add(phoneCallLink);
phoneCallLink.EntityAlias = "products";
EntityCollection AllProductsWithSpecificCallsNotOpen = new EntityCollection();

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Friyank 944 on at

Like (0)

Report

Are you using System Entity or custom Entity of product

I Triggered Same Query

ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

#region Connect To CRM in just one lines

CrmServiceClient Crmconn = new CrmServiceClient(ConfigurationManager.ConnectionStrings["CrmOnlineUrl"].ConnectionString);

#endregion

if (!Crmconn.IsReady)

{

Console.WriteLine("No Connection was Made.");

return;

}

QueryExpression query = new QueryExpression("product");

query.Criteria.AddCondition(new ConditionExpression("statecode", ConditionOperator.Equal, 0));

query.ColumnSet = new ColumnSet("productid");

LinkEntity phoneCallLink = new LinkEntity("product", "phonecall", "productid", "regardingobjectid", JoinOperator.LeftOuter);

FilterExpression filter1 = new FilterExpression(LogicalOperator.And);

filter1.Conditions.Add(new ConditionExpression("statecode", ConditionOperator.NotEqual, 0));

phoneCallLink.LinkCriteria = filter1;

phoneCallLink.EntityAlias = "products";

EntityCollection AllProductsWithSpecificCallsNotOpen = new EntityCollection();

var data = Crmconn.RetrieveMultiple(query);

It worked and returned Records as well

I made two changes in query

Changed

query.Criteria.AddCondition(new ConditionExpression("productstatus", ConditionOperator.Equal, 0));

To

query.Criteria.AddCondition(new ConditionExpression("statecode", ConditionOperator.Equal, 0));

and

Changed

query.ColumnSet = new ColumnSet("product");

To

query.ColumnSet = new ColumnSet("productid");

Was this reply helpful? Yes No
Suggested answer

Shidin Haridas 3,497 on at

Like (0)

Report

Your code seems fine and should be working as expected, except for this line of code:

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Below is an example. Just modify it to work for your entities:

private EntityCollection RetrieveListMembers(Guid listid)
{
QueryExpression query = new QueryExpression()
{
EntityName = "contact",
ColumnSet = new ColumnSet(new string[] { "contactid", "fullname", "firstname", "lastname", "emailaddress1", "donotemail", "statecode" }),
LinkEntities =
{
new LinkEntity()
{
LinkToEntityName = "listmember",
LinkToAttributeName = "entityid",
LinkFromEntityName = "contact",
LinkFromAttributeName = "contactid",
LinkCriteria =
{
Conditions =
{
new ConditionExpression("listid", ConditionOperator.Equal, listid)
}
}
}
}
};

try
{
EntityCollection rc = service.RetrieveMultiple(query);
return rc;
}
catch (FaultException<OrganizationServiceFault> ex)
{
throw new InvalidPluginExecutionException("An error occurred in the plug-in. ", ex);
}
}

Hope this helps.

Was this reply helpful? Yes No