The Super Search option allows users to build complex query definitions. Compared to the Search / Request function, which is a simple, form-based quick search, the Super Search is a complete query maker. It includes the following features not supported by Search / Request.

1. Support for multiple conditions joined by AND/OR. Search / Request fields are always connected by AND.

2. Support for multiple conditions evaluated on the same field. Search / Request can only compare a field against a single value.

3. Support for multiple comparison operators including:

4. Supports NOT. For example, NOT x=1 (true whenever x is not equal to 1) Search / Request does not support NOT.

5. Conditions can be logically grouped using parenthesis. This feature allows user to design queries whose evaluation to TRUE or FALSE is more easily understandable.

6. Query definitions can be saved and used later. A Search / Request query cannot be saved.

To execute a Super Search

1. Establish the conditions for the search. The conditions established will appear as defined and stack up in the condition box. Select the field(s) and the operands (AND, OR, GREATER THAN, LESS THAN, EQUAL TO, etc) desired for the databases to be searched on.

2. Each search can contain up to 10 conditions. Each condition can contain up to 12 comparison values (e.g. 'city equals Cleveland, Chicago, Los Angeles or New York') allowing for a total of 120 comparisons per search).

3. Conditions may be added, edited, deleted, moved or changed by utilizing the options listed.

4. Upon completion of the search requirements SAVE DEFINITION and give the search an appropriate name to be used at a later date. This will save time for similar searches at a later date.

5. Select LOAD DEFINITION to load a previously defined search.

REPORT

1. Choose the fields to appear on the report to be created based on the search performed.