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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

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);

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

You just need to use like below

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

Was this reply helpful? Yes No
Suggested answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No