|
- Subject: Re: And/Or View Filtering
- Author: Lon Orenstein
- Date: 01 Feb 2008
- References: 1
Yes, you're correct but here's the workaround.
After you create the three entries on the Advanced tab, click the SQL tab
and you'll see the SQL statements that BCM will use to create the filter.
Click on the box at the bottom, "Edit these criteria directly", and you can
change the AND's to OR's like this:
(NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/8084001f"
IS NULL) OR
NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/8094001f"
IS NULL) OR
NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/80a4001f"
IS NULL))
HTH,
Lon
___________________________________________________________
Lon Orenstein
pinpointtools, llc
Lon@pinpointtools.com
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com
"Jeeslawees" <Jeeslawees@discussions.microsoft.com> wrote in message
news:81996A8B-617B-4521-8FD4-216572CF2EB5@microsoft.com...
After you create the three entries on the Advanced tab, click the SQL tab
and you'll see the SQL statements that BCM will use to create the filter.
Click on the box at the bottom, "Edit these criteria directly", and you can
change the AND's to OR's like this:
(NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/8084001f"
IS NULL) OR
NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/8094001f"
IS NULL) OR
NOT("http://schemas.microsoft.com/mapi/id/{00062004-0000-0000-C000-000000000046}/80a4001f"
IS NULL))
HTH,
Lon
___________________________________________________________
Lon Orenstein
pinpointtools, llc
Lon@pinpointtools.com
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com
"Jeeslawees" <Jeeslawees@discussions.microsoft.com> wrote in message
news:81996A8B-617B-4521-8FD4-216572CF2EB5@microsoft.com...
> Let's say I'm trying to create a Business Contact View that only shows
> Contacts that have one or more e-mail addresses in the record. I click
> Filters, then Advanced, then select Field=E-mail, with Criteria=is not
> empty,
> then click Add To List. Ditto for E-Mail2. Ditto for E-Mail3. These 3
> Filters result in NO Contacts showing in the View, apparently because the
> Outlook BCM assumes a boolean operator of "AND" between all criteria on
> the
> filter list. So in this example, unless the Contact has an e-mail address
> in
> ALL 3 e-mail fields, the Contact will not show in the View.
>
> My questions are:
> - Is my AND operator assumption correct? Is it hard coded in the BCM
> Advanced Filter sequence?
> - Is there any way to change the boolean operator to "OR"? (my current
> cheapo contact mgr s/w does this)
> - What is the MORE Advanced Filter button for? Does it actually work? No
> matter what I do it does not activate.
> - Anyone have a work around for this dilemma?
>
> Thanks,
> Rick
> Contacts that have one or more e-mail addresses in the record. I click
> Filters, then Advanced, then select Field=E-mail, with Criteria=is not
> empty,
> then click Add To List. Ditto for E-Mail2. Ditto for E-Mail3. These 3
> Filters result in NO Contacts showing in the View, apparently because the
> Outlook BCM assumes a boolean operator of "AND" between all criteria on
> the
> filter list. So in this example, unless the Contact has an e-mail address
> in
> ALL 3 e-mail fields, the Contact will not show in the View.
>
> My questions are:
> - Is my AND operator assumption correct? Is it hard coded in the BCM
> Advanced Filter sequence?
> - Is there any way to change the boolean operator to "OR"? (my current
> cheapo contact mgr s/w does this)
> - What is the MORE Advanced Filter button for? Does it actually work? No
> matter what I do it does not activate.
> - Anyone have a work around for this dilemma?
>
> Thanks,
> Rick
| 31 Jan 2008 | And/Or View Filtering | .Jeeslawees |
| 01 Feb 2008 |  Re: And/Or View Filtering | .Lon Orenstein |
| 01 Feb 2008 |  Re: And/Or View Filtering | .Jeeslawees |
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)
All times are in (US) Eastern Daylight Time (GMT -4:00)