Can I Apply Two Filters to Task View?

[mtbcpa]

It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?

 

[Diane Poremsky {MVP}]

when you use two of the same criteria they are OR'd together. Try using abc
AND xyz as the condition (it works with some fields but may not work with
all) or use the QueryBuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm









** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

 

[Diane Poremsky {MVP}]

oops - if you AND them it won't work unless an item uses both categories .
You could try abc OR xyz on one like or just use querybuilder.

Working with double negative queries can really be confusing. OR fails
because when it checks the first criteria, it finds all that do not contain
abc as expected... then when it looks for those that don't contain xyz, it
finds abc because it doesn't contain xyz.

Outlook is reading the two lines like this:
(doesn't contain abc) or (doesn't contain xyz)
but you need:
doesn't contain (abc or xyz).

 

[Brian Tillman]

It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?

See if this helps:
<http://groups.google.com/group/micr...read/thread/fb7fc1b1b0a01ef7/46292dddbdfa4336>

 

[Diane Poremsky {MVP}]

1. you can't run rules on tasks.
2. the tasks already have a category. They need a filter that allows a
double negative. QueryBuilder will allow this. They can also use the SQL
tab to edit the query, although that method seems a bit buggy in Outlook
2007 (queries that Outlook created fail if you copy and paste them).









** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

 

[Brian Tillman]

1. you can't run rules on tasks.

D'oh! I missed some important things in the original message, didn't I?