Using Operators in Advanced Finds and Rules

When you click Advanced Find, the Advanced Find dialog box appears. 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. With the exception of the []Contains and [x] Does Not Contain, all of the operators use a string pattern algorithm to find matching items. For example, mac would find all items with mac, macos, macintosh, etc. You can use wildcard characters and switches as discussed in Using Wildcard Characters and Switches in Advanced Finds and Rules.

The []Contains and [x] Does Not Contain operators use a whole word index that matches the entire word and not a set of characters included in any word. However, you should not include punctuation with the words. For example,” [OS]” does not find any results; however, “OS” finds “[OS]” and other words such as “cost”, “across”, and “post.”

Operator

Example

Result Includes

= Equal To

Item Type = Mail

Only mail messages.

! Not Equal To

Item Type ! Appointment

All item types except appointments.

< Less Than

Number Accepted < 4

Items in which fewer than 4 recipients accepted.

<= Less Than or Equal To

Number Accepted <= 4

Items in which 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 in which the number of recipients who accepted equals the total number of recipients.

! Not Equal to Field

Number Read ! Number Accepted

Items in which 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. Contains does not support wildcard characters.

[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. Does not support wildcard characters.

|-> Begins With

To -> cli

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

= Matches

Subject = customer reports

Items where the Subject field reads “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/08

Items that were created on May 29, 2008.

> After Date

Created > 5/29/08

Items that were created after May 29, 2008.

>= On or After Date

Created >= 5/29/08

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

< Before Date

Created < 5/29/08

Items that were created before May 29, 2008.

<= On or Before Date

Created <= 5/29/08

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

For trademark and copyright information, see Legal Notices.