Filter - Advanced - Select Fields with OR instead of AND

[MattG]

When setting up a Filter and Using the Advanced - Field function, is it
possible to effectively use the "OR" operator rather than the apparent "AND"
default. For example, I want to see only To Do's that are due today OR have
priority = high. There are a billion fields to choose from but apparently
only AND not OR. There is a "more advanced" button but it is grayed out
and unavailable. I tried to use the SQL screen and change "AND" to "OR" but
that does not work, either. Any ideas? Thanks in advance.

 

[Sue Mosher [MVP-Outlook]]

Can you give us an example of a typical search that isn't working when you replace AND with OR?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[MattG]

Sue -- Here is the example SQL statement:

(%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")% OR "urn:schemas:httpmail:importance" = 2)

From the samples I have tested, the 'today' condition appears to be the
problem. And, oddly, sometimes it works but most times it does not.

 

[Sue Mosher [MVP-Outlook]]

Sorry, but I don't have MAPI schema tags memorized. What field does the first expression refer to?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Ken Slovak - [MVP - Outlook]]

It should be the due date if I'm not mistaken.




Sorry, but I don't have MAPI schema tags memorized. What field does the
first expression refer to?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers