How to filter by postal code range?

(0) Share

Report

Posted on by saadzag

1,145

Hello,

I have to do an ExecuteMultiple, using a filter by the standard field "address1_postalcode".

The condition of the filter is that the postal code shoud be in a range.

I used this two filters, but the result does'nt take into account the condition:

 filter.Conditions.Add(new ConditionExpression("address1_postalcode", ConditionOperator.LessThan, postalcodeMax));
 filter.Conditions.Add(new ConditionExpression("address1_postalcode", ConditionOperator.GreaterThan, postalcodeMin));

PostalcodeMin and postalcodeMax are integers, and I know that postalCode field is string.

Do you have any idea?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi saadzag,

address1_postalcode field is of string type so number operators won't work here. We usually create custom postal code field of type whole number and use that for this kind of stuff.

The option I can think for you is also on the same lines i.e. create a new custom field of type whole number, update the values and use this field instead.

This would also help you in advance find queries as well.

Thanks,

Ravi

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Was this reply helpful? Yes No