Advanced Find Conditions

(0) Share

Report

Posted on by Ben Markland

Is there any way to build a single condition for a text field using the OR clause as opposed to building a new row for each one?

What I have to do today:

City Equals Boston

OR City Equals New York

City Equals San Francisco

What I would like to do:

City Equals Boston or New York or San Francisco

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Abed Haniyah 4,287 on at

Like (0)

Report
Copy link

Link copied!

Hello Ben Markland,

There is no way to do this a text field, If your filed is a Lookup filed or Option Set, then you can do it :)

Hope this helps,

Abed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ben,

Advanced Find user interface doesn't support to build "in" operator for text field, however if you really need to build this query you can directly build fetch xml queries

Example

<fetch mapping="logical" count="50" version="1.0">
<entity name="entity">
<filter type="or">
<condition attribute="description" operator="in">
<value>123</value>
<value>456</value>
<value>789</value>
</condition>
</filter>
</entity>
</fetch>

Regards,

Tenison

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Ben,

I would like to share you this useful links which talks about the new Operato in the Advanced Fin with Dynamics CRM 2015.

+ www.powerobjects.com/.../new-operators-advanced-find-dynamics-crm-2015

It is important to mention that you can use expression (under and not-under)

Best Regards,

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report
Copy link

Link copied!

ben,

The OOB Advanced find doesn't support it.

If you use that, you need to do query in advanced find using one by one you defined City equals Boston, City equals NY, City equals SF, and so on then you group in OR.

Was this reply helpful? Yes No