54.3 Using Operators in Advanced Finds and Rules

When you use Advanced Find, as described in Composing an Advanced Find, the Advanced Find dialog box appears. Select the field in the first drop-down list, and then select the operator from the Operator drop-down list Operator List icon. The available operators depend on the field you have selected in the first drop-down list.

When you select a field that allows you to type text, such as Subject, the following operators are available:

  • Contains

  • Does Not Contain

  • Begins With

  • Matches

  • Not Equal To

The wildcard characters and switches that these text-based operators support differ depending on the operator. For more information, see Using Wildcard Characters and Switches in Advanced Finds and Rules.

For more information about each text-based operator and the results they include, as well as all other operators, see the following table:

Operator

Example

Result Includes

= Equal To

Item Type = Mail

Only mail messages.

! Not Equal To

Item Type ! Appointment

All item types except appointments.

Searches on individual characters. Supports * and ? wildcards. You can include punctuation, white space, and parts of words.

< Less Than

Number Accepted < 4

Items that fewer than 4 recipients accepted.

<= Less Than or Equal To

Number Accepted <= 4

Items that 4 or fewer recipients accepted.

> Greater Than

Number Read > 6

Items that more than 6 recipients read.

>= Greater Than or Equal To

Number Read >= 6

Items that 6 or more recipients read.

= Equal to Field

Number Accepted = Total Recipients

Items where the number of recipients who accepted equals the total number of recipients.

! Not Equal to Field

Number Read ! Number Accepted

Items where the number of recipients who read the item is not equal to the number of recipients who accepted.

< Less Than Field

Number Opened < Total Recipients

Items where the number of recipients who opened the item is less than the total number of recipients.

<= Less Than or Equal to Field

Number Opened <= Total Recipients

Items where the number of recipients who opened the item is less than or equal to the total number of recipients.

> Greater Than Field

Number Opened > Number Deleted

Items in which the number of recipients who have opened the item is greater than the number of recipients who have deleted the item.

>= Greater Than or Equal to Field

Number Opened >= Number Deleted

Items where the number of recipients who have opened the item is greater than or equal to the number of recipients who have deleted the item.

[ ] Includes

Item Status [ ] Completed

Items that have been completed.

! Does Not Include

Item Status ! Accepted

Items that have not been accepted.

[ ] Contains

From [ ] Bill

Items where the From field contains "Bill," such as items from Bill Jones, Bill Smith, and so on.

Searches on entire words. Does not support * and ? wildcard characters. However, does support AND, OR, and NOT switches (with their corresponding punctuation &, |, and !). Quotation marks surrounding a phrase searches for the complete phrase. All other punctuation is ignored. White space is considered an AND.

[x] Does Not Contain

From [x] Bill

Items where the From field does not contain “Bill,” such as items from Bill Jones, Bill Smith, and so on.

Searches on entire words. Does not support * and ? wildcard characters. However, does support AND, OR, and NOT switches (with their corresponding punctuation &, |, and !). Quotation marks surrounding a phrase searches for the complete phrase. All other punctuation is ignored. White space is considered an AND.

|-> Begins With

To |-> cli

Items where the To field begins with “cli” such as “Client Group” or “Clive Winters.”

Searches on individual characters. Supports * and ? wildcard characters. You can include punctuation, white space, and parts of words.

= Matches

Subject = customer reports

Items where the Subject field reads “Customer Reports.”

Searches on individual characters. Supports * and ? wildcard characters. You can include punctuation, white space, and parts of words. For example, with the Subject field, you can use the Matches operator and search for *report* and find the subject Customer Reports.

= On

Created = Today

Items that were sent today.

>= On or After

Created >= Yesterday

Items that were sent yesterday or later.

> After

Created > Yesterday

Items that were sent later than but not including yesterday.

< Before

Due/End Date < Tomorrow

Tasks that are due before tomorrow.

<= On or Before

Due/End Date <= Tomorrow

Tasks that are due tomorrow or earlier.

-> Within

Due/End Date -> 3 Day

Tasks that are due between and including today and three days after today.

<- Previous

Due/End Date <- 3 Day

Tasks that were due between and including today and three days before today.

= On Date

Created = 5/29/12

Items that were created on May 29, 2012.

> After Date

Created > 5/29/12

Items that were created after May 29, 2012.

>= On or After Date

Created >= 5/29/12

Items that were created on or after May 29, 2012.

< Before Date

Created < 5/29/12

Items that were created before May 29, 2012.

<= On or Before Date

Created <= 5/29/12

Items that were created on or before May 29, 2012.