Search Data Fields

Level I
Sales Associate

Revision Date: August 7, 2015

12950

Search Data Fields

SEARCH DATA FIELDS

It is not necessary to enter specific data if you wish to UPDATE, REMOVE, QUERY or VIEW a particular record.  Searching for a record may be easily accomplished with the aid of a “pattern matching” character.

Upon selecting a UPDATE, REMOVE, QUERY, or VIEW from the ring menu, you may simply use the arrow or return keys to move to the data field to be searched.  You may either enter the specific information or use pattern matching characters to assist in searching for records.  Upon completion of entering the data, press ESC to begin the search.

The following pattern matching characters may be utilized when searching a field for specific information in all programs:

*    An asterisk replaces zero or more characters.  This is also known as a Wild Card.  When using a wild card you will press ENTER until the cursor is at a field of know information.  Enter the known info with the “*” and press ESC.  If a wild card was used and there is more than one record that’s meets that criteria, a specific record will need to be accepted.  Select NEXT to scroll for the correct part.  Select PREVIOUS to scroll back for the correct record.  When the desired record is found, select ACCEPT.  Select HELP to open a HELP window.  Select EXIT from the ring menu.

Examples:  0HC*     Searches for all records beginning with a “0HC”

                   *Z5        Searches for all records ending with “Z5”

                   *0250C01250Z*     Searches for all records containing “0250C01250Z.”  You should note that the middle searches take longer than beginning or end searches.

                    *PAINT*     In a description field this will search for all records containing “PAINT.”

:     The range function causes a search for records within a beginning and ending range.  Example: 3020:4050 Searches for all records beginning at 3020 and ending at 4050.

|     The piping function causes a search for specific values.

         Examples:     342|239      Searches for the specific records 342, 23 and 9.

                               ABC|XYZ     Searches for the specific records ABC and XYZ.