Understanding fliters in Contact views

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using OL 2002 SP3; I have multiple categories for my contacts. Some contact
are in 3 or more categories. Trying to create a contact view for only current
business contacts. I have created the view "temp"; applied filters to the
view under 'Customize current view' as:
Categories - doesen't contain - Past
Categories - doesen't contain - Jacks Personal
the SQL tab shows 'OR' being applied [but I am not editing criteria directly]
however contacts with categories 'OFS, Lithchem, Jacks Personal' show up in
the view as well as contacts with only 'Jacks Personal'
I have checked spelling and capitaization - why is this happening?
 
Think about your logic: 'OFS, Lithchem, Jacks Personal' meets one of your two criteria (Categories - doesen't contain - Past) and therefore an item with that value will appear.

Perhaps you want And not Or?
 
using the SQL tab, I changed OR to AND between the two criteria - now the
"Jacks Personal"-only contact is eliminated from the view but I now see [more
investigation] that with either OR or AND there are also some 'Past" contacts
listed. There is even one contact with only 'Past' and Jacks Personal'
categories - and it is listed!
I want to filter out any contact that contains either the 'Past' category or
one that contains 'Jacks Personal'. Each is to be filtered out.
Am I going crazy?

Sue Mosher said:
Think about your logic: 'OFS, Lithchem, Jacks Personal' meets one of your two criteria (Categories - doesen't contain - Past) and therefore an item with that value will appear.

Perhaps you want And not Or?


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Jack S. said:
Using OL 2002 SP3; I have multiple categories for my contacts. Some contact
are in 3 or more categories. Trying to create a contact view for only current
business contacts. I have created the view "temp"; applied filters to the
view under 'Customize current view' as:
Categories - doesen't contain - Past
Categories - doesen't contain - Jacks Personal
the SQL tab shows 'OR' being applied [but I am not editing criteria directly]
however contacts with categories 'OFS, Lithchem, Jacks Personal' show up in
the view as well as contacts with only 'Jacks Personal'
I have checked spelling and capitaization - why is this happening?
Click to expand...
Click to expand...
 
Because you can have multiple values for and item in the category
field, the filter/SQL logic for categories is different than for fields
that have only one value at a time.

Also, make sure that all category values are in the Master Category
List and that the Category values in your filters correspond exactly
and only to those values.

Applying "NOT" and "OR" to the same filter can make for a pretty weak
filter.
 
does this mean I cannot do what I want - filter out all 'Past' and all 'Jacks
Personal' catagories from being displayed?
Can you explain more fully how "the filter/SQL logic for categories is
different than for fields"?
bottom line - can any one explain how to accomplish my task? or tell me it
is not possible - and if not why not?
 
Back
Top