This section contains samples of valid filter expressions.
For the address book, you can use filters similar to the following:
- (Name CONTAINS ‘Smi*’)
- (<First Name> MATCHES "John")
- (<Last Name> CONTAINS ‘Smi*’)
- (<E-Mail Address> CONTAINS "*novell.com")
- (Department CONTAINS "System Test")
NOTE:Field names that contain spaces must be wrapped between brackets (< >).
The following filter expressions work for other queries:
- (SUBJECT CONTAINS "Internet")
- (AUTHOR MATCHES "Ralph Spoilsport")
- (MESSAGE BEGINSWITH "Now Hear This")
- (MESSAGE CONTAINS CASE ('Inter*' OR 'Intra*') AND ("Test" .. "Plan"))
- (FROM MATCHES <MY_BOSS, STRING>)
- (TASK)
- (CREATE_DATE >= YESTERDAY AND CREATE_DATE <= TODAY)
- (FROM CONTAINS "TJEFFERSON" OR FROM CONTAINS "JADAMS") AND (MESSAGE BEGINSWITH "When in the course" AND CREATE_DATE = 1776/7/4)
- (DUEEND_DATE <= TOMORROW)
- (START_DATE >= 2012/2/5 AT 8:00:00)
- (CREATE_DATE >= THIS_YEAR 31)
- (<BIRTHDAY, DATE> = THIS_MONTH)
- (SIZE < 12000)
- (NUMBER_ACCEPTED = TOTAL_RECIPIENTS)
- (<TOTAL_EMPLOYEES, NUMERIC> > 50)
- (PRIORITY = HIGH)
- (ATTACHMENT_TYPE = OLE)
- (BOX_TYPE = INCOMING)
- (APPOINTMENT AND NOT ACCEPTED)
- (MAIL OR TASK) AND (NOT HIDDEN)