Combine 'AND' and 'OR' in Query

In the SDK of Microsoft CRM there are some Fetch XMl samples. In the examples
filter-types like 'and' and 'or' are being used. I want to combine these two,
something like:

<filter type='and'><condition1>
<filter type='or'>
<filter type='and'><condition>

Does anyone know if this is possible, and if so, how this can be done?

Br.

cathyall
Tue Feb 22 19:18:26 CST 2005

Not sure if this directly answers your question, but using the standard
filtering, "AND" is the default when entering more than one criteria.
You can have an "OR" within the one criteria by entering eg "First
Name" contains/equals "Bill;William". Your next criteria would default
to "AND".

Chris Plenter wrote:
> In the SDK of Microsoft CRM there are some Fetch XMl samples. In the
examples
> filter-types like 'and' and 'or' are being used. I want to combine
these two,
> something like:
>
> <filter type='and'><condition1>
> <filter type='or'>
> <filter type='and'><condition>
>
> Does anyone know if this is possible, and if so, how this can be
done?
>
> Br.