Query expression using customerid

(0) Share

Report

Posted on by Goutham A

I need to write a query expression using customerid but the below query is throwing format exception. Please help

QueryExpression query = new QueryExpression("opportunity");
Guid contactid = new Guid("23E62DCE-F154-E843-814K-005056BB4062");
query.Criteria.AddCondition("customerid",ConditionOperator.Equal,new EntityReference("contact",contactid));
EntityCollection result = _orgService.RetrieveMultiple(query);

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report

RE: Query expression using customerid

Hi Lathin,

You dont need to pass the Entity reference in the above code,

Please try with below code,

QueryExpression query = new QueryExpression("opportunity");

Guid contactid = new Guid("23E62DCE-F154-E843-814K-005056BB4062");

query.Criteria.AddCondition("customerid",ConditionOperator.Equal,contactid);

EntityCollection result = _orgService.RetrieveMultiple(query);

Best Regards,

Shahbaaz
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

RE: Query expression using customerid

You just need to use like below

query.Criteria.AddCondition("customerid",ConditionOperator.Equal,contactid);
ashlega 34,477 on at

Like (1)

Report

RE: Query expression using customerid

I don't think you need to pass EntityReference - just pass the Guid to your condition
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Query expression using customerid

Hi ,

Try with this , replace column name which you want to retrieve.

Guid contactid = new Guid("23E62DCE-F154-E843-814K-005056BB4062");

ConditionExpression condition1 = new ConditionExpression();

condition1.AttributeName = "customerid";

condition1.Operator = ConditionOperator.Equal;

condition1.Values.Add(contactid);

FilterExpression filter1 = new FilterExpression();

filter1.Conditions.Add(condition1);

QueryExpression query = new QueryExpression("opportunity");

query.ColumnSet.AddColumns("column1", "column2"); // Replace column name .

query.Criteria.AddFilter(filter1);

EntityCollection result1 = _orgService.RetrieveMultiple(query);