How can Advanced Find be used to perform the following search:

List all Contacts...
- where their Job Title is "Chief Executive"
OR
- where a custom field on a custom related entity is "Chief Executive"

Can OR conditions only be placed on fields within the same entity?

This seems like a bit of a hole in an otherwise extremely powerful tool.

"Optevia" <keithdelarge@gmail.com> wrote:

That's correct, in the Advanced Find UI, OR conditions can only be placed
on fields within the same entity. FetchXml, the query definition language
that Advanced Find generates, can support OR queries, but requires SQL
knowledge since the syntax is similar.


--
Tao Yue
Microsoft Dynamics CRM Development
This posting is provided "AS IS" with no warranties, and confers no rights.