OL98: Unpredictable Results with the Advanced Tab of Advanced Find (210257)

MORE INFORMATION

Filters can be conditions or sets of conditions to determine what items are shown in a particular folder. Using these filters with views, you can customize the look of your folders. It is important to understand the relation of conditions, and arguments within the conditions, to the underlying logic.

To create sucessful advanced queries, two points need to be understood:

• Multiple conditions are AND values. For example, the condition is true if A and B are both true.
• Multiple arguments within a condition are OR values. The argument is true if A or B is true.

An AND statement would be:
Rob and Lunch must both exist in the message for a TRUE condition to exist.

An OR statement would be:
In this example, if any of the three people on the From line match with the Subject, then the statement will be TRUE.

To Set Up a Multiple Statement Query

1. On the Tools menu, click Advanced Find.
2. On the Advanced tab, click Field. In the list, point to a field category and click to select a field from the field list.
3. In the Conditions list, click to select the condition to apply to the field's value.
4. In the Value field, type a value, or click to select one from the list if available. Separate multiple values with a semicolon (;) to create the implied OR logical operator in the criteria statement.
5. Click Add to List. This places the query statement in the Find items that match these pane.

Repeat these steps to select multiple query statements. Each line in the criteria pane is connected with an AND statement.

The Advanced Find uses an implied AND between each query statement. It uses an implied OR between arguments contained within the query statement.