Outlook 2002 - filtering categories using inclusion and exclusion

  • Thread starter Thread starter Fred_Garvin
  • Start date Start date
F

Fred_Garvin

Here is a quite simple question for you on the use of Outlook 2002.

The situation : some tasks have been assigned to «category A» and
«category B».

The question : how can you filter views that will permit you to see
all tasks that include «category A» but exclude as well all tasks that
include «category B» ? Simple enough ? I have browsed extensively on
the matter but have yet to find a solution. SQL filtering has not
permitted me to filter with success my desired views. I understand
that I probably lack a few basic rules using SQL DAV operators.

Can you please help ?

Desperately seeking the appropriate view
 
Adding this DASL syntax filter on the SQL tab of the
Filter dialog worked for me. It's just simple AND and NOT
operators.

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-com:office:office#Keywords"
= 'A') AND NOT ("urn:schemas-microsoft-
com:office:office#Keywords" = 'B')

You could also use

AND "urn:schemas-microsoft-com:office:office#Keywords"
<> 'B')

for the last expression.
Click to expand...

_____________________________________

Dear Sue,

Wow ! Thank you so much. Your suggestion worked perfectly ! I
looked extensively through KB and Outlook related sites, but to no
avail. I am not a programmer and lack some knowledge about SQL (in
particular SQL DAV).

Once again, thank you very much :)

Edgar
 
DASL is documented in the Exchange SDK, but I find it far easier to create a filter using the normal options, then take a look at it on the SQL tab and start experimenting.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top