= 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 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 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 field begins with “cli” such as “Client Group” or “Clive Winters.” |
= Matches |
Subject = customer reports |
Items where the 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. |