User's Manual

Searching for Records
Wildcard Searching
3
3-11
Date
For all operators except Approx, search criteria and field data are compared
as dates on a time line. The display format is ignored. Blank data is less than
any Date value.
For Approx, search criteria and field data are compared by the rule “is the
field data within +
2 weeks of the search criteria?”
Pick
For all operators, search criteria and field data are compared in the order they
appear within the list. The item at the top of the list is “less than” the item
immediately following it, etc.
For example, given the choices within the Function field, if you were to
include in your Quick Search the value “Indicator”, and select the < operator,
your search would find all records containing the Function field value
“Controller” or “Converter”.
There is no Approx feature for Pick fields. The Approx is treated as an
equals operator (=). (Note that some Pick fields may be displayed as a
collection of radio buttons.)
YesNo
For all operators, the search criteria and field data must exactly meet the
comparison criteria with the “on” value being greater than the “off” value.
Blank data is less than any YesNo value. (Note that some YesNo fields may
appear as checkboxes.)
There is no Approx feature for YesNo fields. The Approx is treated as an
equals operator (=).