User's Manual

DPC/TRACK
Users Manual
3-12
Arrayed Fields
As discussed earlier, arrayed fields contain multiple values. Listed below are the
different arrayed field types and the rules that govern operators within those
arrayed field types.
Text
For all operators except Approx, each of the specified field data elements
must meet the search criteria when compared against each of the search
criteria elements. The first field data element must meet the search criteria
when compared against the first element of the search criteria, the second
field data element must meet the search criteria when compared against the
second element of the search criteria, etc. Individual elements are compared
from left to right, with numbers being less than alphabetical characters. An
upper-case letter is equal in value to the same letter in lower case. Blank data
is less than an ! symbol, which is less than a " symbol, which is less than any
other Text value, per Table 3-1. If any single field data element does not
meet the criteria of any search criteria element, or the field data array differs
in size from the search criteria array, the field data array will not meet the
search criteria.
For Approx, if any of the field data elements contain any of the search
criteria elements, the entire array is considered to meet the search criteria.
This rule is ignored if an *, ? or | symbol is present, in which case the rules
for wildcard searching apply, unless these symbols are preceded with a \.
For example, perform a search on an arrayed Text field, using the Approx
operator, given the following search criteria and field data:
Search Criteria Field Data
corrosion The valve was stuck.
broke I noticed a broken pin.
cracked No comment.
The search would find the record containing the field data because the second
field data element contained one of the search criteria elements (broke).
An example of an arrayed Text field is the Setup Messages field.
DPC/TRACK also includes arrayed Number fields, such as the Testpoints
field.