This morning when I launched Outlook 2003, a bunch of calendar items
that I normally have filtered out suddenly appeared. I note the Outlook
build (from Help About Outlook) is now 11.8010.8036.

What used to work that now appears to not work is,
under View Arrange By Current View Customize Current View Filter
Advanced tab

Subject doesn't contain blaha
Subject doesn't contain blahb
Location doesn't contain blahc
Location doesn't contain blahd

Outlook used to do an AND on these; with 8036 it now appears to do an
OR. So, since a subject will never contain both blaha and blahb, and a
location will never contain both blahc and blahd, nothing is getting
filtered out.

The solution is to use the SQL tab instead:

NOT ("urn:schemas:calendar:subject" LIKE '%blaha%' OR
"urn:schemas:calendar:subject" LIKE '%blahb%' OR
"urn:schemas:calendar:location" LIKE '%blahc%' OR
"urn:schemas:calendar:location" LIKE '%blahd%')

Works like a charm!

By the way, if you type something into the SQL tab, then uncheck the
edit box, the contents are lost without an "Are you sure you want to
delete this SQL query?" so be sure to copy it into Notepad if you want
to play around with enabling and disabling it.

Hope this helps,
Charles "Chas" Belov

Charles Belov wrote:
This morning when I launched Outlook 2003, a bunch of calendar items
that I normally have filtered out suddenly appeared. I note the Outlook
build (from Help About Outlook) is now 11.8010.8036.

What used to work that now appears to not work is,
under View Arrange By Current View Customize Current View Filter
Advanced tab

Subject doesn't contain blaha
Subject doesn't contain blahb
Location doesn't contain blahc
Location doesn't contain blahd

Outlook used to do an AND on these; with 8036 it now appears to do an
OR. So, since a subject will never contain both blaha and blahb, and a
location will never contain both blahc and blahd, nothing is getting
filtered out.

The solution is to use the SQL tab instead:

NOT ("urn:schemas:calendar:subject" LIKE '%blaha%' OR
"urn:schemas:calendar:subject" LIKE '%blahb%' OR
"urn:schemas:calendar:location" LIKE '%blahc%' OR
"urn:schemas:calendar:location" LIKE '%blahd%')

Works like a charm!

By the way, if you type something into the SQL tab, then uncheck the
edit box, the contents are lost without an "Are you sure you want to
delete this SQL query?" so be sure to copy it into Notepad if you want
to play around with enabling and disabling it.


I spoke too soon. My workaround appears to work in the 1 Day and 5 Work
Week views but not in the 7 Week or 31 Month views. Unfortunately, my
preferred view is 7 Week. Guess I'll have to put up with 5 Work Week
for now. *sigh*

Charles "Chas" Belov

repeating a condition always uses the "or" operator - its not new to this
build.

http://www.outlook-tips.net/archives/2004/20041229.htm

you could try combining them into 'blaha AND blahb"



--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Charles Belov" wrote in message
...
This morning when I launched Outlook 2003, a bunch of calendar items that
I normally have filtered out suddenly appeared. I note the Outlook build
(from Help About Outlook) is now 11.8010.8036.

What used to work that now appears to not work is,
under View Arrange By Current View Customize Current View Filter
Advanced tab

Subject doesn't contain blaha
Subject doesn't contain blahb
Location doesn't contain blahc
Location doesn't contain blahd

Outlook used to do an AND on these; with 8036 it now appears to do an OR.
So, since a subject will never contain both blaha and blahb, and a
location will never contain both blahc and blahd, nothing is getting
filtered out.

The solution is to use the SQL tab instead:

NOT ("urn:schemas:calendar:subject" LIKE '%blaha%' OR
"urn:schemas:calendar:subject" LIKE '%blahb%' OR
"urn:schemas:calendar:location" LIKE '%blahc%' OR
"urn:schemas:calendar:location" LIKE '%blahd%')

Works like a charm!

By the way, if you type something into the SQL tab, then uncheck the edit
box, the contents are lost without an "Are you sure you want to delete
this SQL query?" so be sure to copy it into Notepad if you want to play
around with enabling and disabling it.

Hope this helps,
Charles "Chas" Belov

Thanks!

This worked:

Subject doesn't contain blaha AND blahb
Location doesn't contain blahc AND blahd

Nevertheless, it does seem as if functionality changed with this build,
as I did not make any changes to whatever I had there before, and it
broke with the build.

Also, it is strange that the SQL rule I listed in my post below works in
the 1 and 5 day views, but not in the 7 and 31 day views. That sounds
like a bug.

Anyway, I'm a happy camper now and thanks for your help.

Charles "Chas" Belov

Diane Poremsky [MVP] wrote:
repeating a condition always uses the "or" operator - its not new to this
build.

http://www.outlook-tips.net/archives/2004/20041229.htm

you could try combining them into 'blaha AND blahb"



"Charles Belov" wrote in message
...
This morning when I launched Outlook 2003, a bunch of calendar
items that
I normally have filtered out suddenly appeared. I note the Outlook
build
(from Help About Outlook) is now 11.8010.8036.

What used to work that now appears to not work is,
under View Arrange By Current View Customize Current View
Filter
Advanced tab

Subject doesn't contain blaha
Subject doesn't contain blahb
Location doesn't contain blahc
Location doesn't contain blahd

Outlook used to do an AND on these; with 8036 it now appears to do
an OR.
So, since a subject will never contain both blaha and blahb, and a
location will never contain both blahc and blahd, nothing is getting
filtered out.

The solution is to use the SQL tab instead:

NOT ("urn:schemas:calendar:subject" LIKE '%blaha%' OR
"urn:schemas:calendar:subject" LIKE '%blahb%' OR
"urn:schemas:calendar:location" LIKE '%blahc%' OR
"urn:schemas:calendar:location" LIKE '%blahd%')

Works like a charm!

By the way, if you type something into the SQL tab, then uncheck
the edit
box, the contents are lost without an "Are you sure you want to delete
this SQL query?" so be sure to copy it into Notepad if you want to
play
around with enabling and disabling it.