Previously we have given filter examples only using the compare value of EQ. One example searches for all contact records in California and another sample filter searching for all contact records in California OR New York. The following examples use each of the compare values except %W, %L and %R which are explained further in a related topic:
Example #1 NE = Not equal to
In this filter we want all contact records in California except for those in San Francisco. The State field ID is STA and the City field ID is CIT.
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
STA |
____ |
____ |
__ |
EQ |
"CA"____________________________ |
||
AND |
CIT |
____ |
____ |
__ |
NE |
"San Francisco"___________________ |
|
____ |
______ |
____ |
____ |
__ |
____ |
________________________________ |
|
____ |
______ |
____ |
____ |
__ |
____ |
________________________________ |
|
Example #2 GT = greater than
In this filter we want all contact records in San Francisco with all the Zip codes greater than 941xx. The City field ID is CIT and the Zip code field ID is ZIP.
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
CIT |
___ |
____ |
__ |
EQ |
"San Francisco"___________________ |
||
AND |
ZIP |
___ |
____ |
__ |
GT |
"941"___________________________ |
|
____ |
______ |
____ |
____ |
__ |
____ |
________________________________ |
|
____ |
______ |
____ |
____ |
__ |
____ |
________________________________ |
|
Example #3 LT = less than
In this filter we want all contact records in San Francisco with all the Zip codes greater than 941xx but less than 94199. The City field ID is CIT and the Zip code field ID is ZIP.
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
CIT |
____ |
____ |
__ |
EQ |
"San Francisco"___________________ |
||
AND |
ZIP |
____ |
____ |
__ |
GT |
"941"___________________________ |
|
AND |
ZIP |
____ |
____ |
__ |
LT |
"94199"_________________________ |
|
____ |
______ |
____ |
____ |
__ |
____ |
________________________________ |
|
Example #4 GE = greater than or equal to
In this filter we want all contact records in San Francisco with all the Zip codes greater than and equal to 94111. The City field ID is CIT and the Zip code field ID is ZIP.
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
CIT |
___ |
____ |
__ |
EQ |
"San Francisco"___________________ |
||
AND |
ZIP |
___ |
____ |
__ |
GE |
"94111"__________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|
Example #5 LE = less than or equal to
In this filter we want all contact records in San Francisco with all the Zip codes less than and equal to 94111. The City field ID is CIT and the Zip code field ID is ZIP. I.
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
CIT |
___ |
____ |
__ |
EQ |
"San Francisco"___________________ |
||
AND |
ZIP |
___ |
____ |
__ |
LE |
"94111"__________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|
Example #6 All owned contact records: In this filter we want all contact records "owned" by userID, xxxxxxx. Whenever a contact record is created the userID of the person creating the contact record is automatically updated in the OWN field (presuming you are using the default).
Filter Maintenance |
|||||||
and /or |
include if field |
position /length |
upper case |
compare type |
compare number, or "characters" or &fieldName |
or %V (dept) or %T (date) or %U (user id) |
|
OWN |
___ |
____ |
__ |
EQ |
"xxxxxx"_________________________ |
||
____ |
_____ |
___ |
____ |
__ |
____ |
________________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|
____ |
_____ |
____ |
____ |
__ |
____ |
_________________________________ |
|