Finding Records in Admin Pages

Make sure POP-UP boxes are enabled in your browser.

To find a record (or group of records) you will use the find function. Just about every admin page has a FIND function which works the same way. To perform a [ find record ] operation follow these steps:

IMPORTANT: Make sure you do not have any pop-up blockers enabled.

  1. Enter text or numbers into one or several of the fields displayed on the empty admin page. In this example "Kevin" is typed into the Name field. Fields designated as "Extended Record Data" are ignored by the FIND operation.
  2. Press the [ Find Record ] button
  3. A window will pop open containing the results of this search. If you do not see a search results window open, check to make sure you do not have any pop-up blockers enabled in your browser.
  4. To load one of the records you have found for viewing or modification, click on the [load] link in this search result window.

Hint: Always begin building a new search with an empty entry form. Press the [ Clear Form ] button to clear the form.


This is the pop-up results of a search

This is how to identify "Extended Record Data" fields. All values listed within a lavendar colored box are "Extended Record Data" fields. Extended data fields are ignored by FIND operations.

How Fields are Searched

All text fields labeled _STRING will perform wild card and partial entry matches. i.e. entering “auto” will match entries like auto, automobile, automatic, etc.

All fields labeled _NUMERIC will match the exact number or must include an equality operator. You can preface a numeric entry with the operators listed below (a space is required between an operator and a value):

All date fields labeled _DATETIME must match the date or must include an equality operator. You can preface a date with the operators listed below (a space is required between an operator and a value):

If an equality operator is not specified then all records matching the date will be returned (from midnight to midnight). Any time (hours, minutes, seconds) will be ignored.

Searches using the Primary Record key will always perform an exact match of the key. The Primary Record key is typically the first entry field in an admin page (see list of primary keys for primary DB tables). If you enter a primary key and some other values, the primary key will override all other values because there can be only one match for a primary key.