Query Expression Add Criteria for look up field and optionset.

(0) Share

Report

Posted on by Community Member

Hey guys, i m trying to get data from field with one criteria.
For example:

QueryExpression query = new QueryExpression { EntityName = "Account", ColumnSet = new ColumnSet("accounttype") };
                    query.Criteria.AddCondition("location", ConditionOperator.Equal, "India");

The field of location is optionset. I tried to run this code, but its keep giving me error message. When i tried to change the condition to a field with single line of text type. Its work !!

im wondering that my code can't get value from field except single line of text, multiple text and number.
So my question is, how can i add criteria from a optionset type of field and lookup type of field

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Clem 2,541 on at

Like (1)

Report
Hi Saraswati,

For filtering on OptionSet you need to put the interger value instead of the Label.

So if you go to your entity and then the field you are filtering on "location" you should have the list of values and for India you should see the Value of it.

For the Lookup field, you just need to use the Id of the field, let's assume that your lookup field is Location, you need to add the following where "locationIdYouWant" id the Guid of the India entry in your entity Location.

query.Criteria.AddCondition("location", ConditionOperator.Equal, locationGuidYouWant);

Hope it helps,

Clément

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi clem, i was used the integer value for option set. but it stil give me error message.

query.Criteria.AddCondition("location", ConditionOperator.Equal, 100,000,002);

is that the correct ways to write the code ?

Was this reply helpful? Yes No
Verified answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report

Hi Saraswati,

Instead of comparing with string "India" please compare with value.

query.Criteria.AddCondition("location", ConditionOperator.Equal, optionsetvalueofIndia);
Example:
query.Criteria.AddCondition("location", ConditionOperator.Equal, 100000002);

or
query.Criteria.AddCondition("location", ConditionOperator.Equal, "100000002");

Thanks

Hemant

If my suggestion helped you please mark this post as suggested answer.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hey thanks for the answer, thats work for me.

But how can i did that if using look up form ??

Was this reply helpful? Yes No
Verified answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report

Hi Saraswati,

I guess you want to compare lookup value.

Suppose 'Location' is lookup field.

query.Criteria.AddCondition("location", ConditionOperator.Equal, new Guid("guidofrecord"););

Thanks

Hemant

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thanks hemant

Was this reply helpful? Yes No