Finding Records in Admin Pages

To find a record (or group of records) you will use the find function. Most admin pages have a FIND function. To perform a [ find record ] operation follow these steps:

IMPORTANT PREREQUISITES:

RECORD SEARCH / FIND INSTRUCTIONS:

  1. Enter text into one or more of the entry fields displayed on the empty admin page. In this example "Popcorn" is typed into the FullName field. Fields designated as "Extended Record Data" are ignored by the FIND operation. Note: If you leave all the fields blank the search results will contain all records and/or a maximum of 250 records.
  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

Using search results as a list

To view or work on many different items in a search result list, leave the list open. You can go back to any list and click on the next item in the list to load it. You can even have more than one search result list open at the same time. This is a very useful way to work on a group of records.

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.

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.

Configuring Internet Explorer
In addition to disabling pop-up blocking for the website you must also enable "Navigating windows across different domains."

Step #1: Open tools => Internet Options => Security Options tab
Step #2: Press the custom levels button

Step #3: Find the "Navigating windows and frames across different domains" options and enable it.