The Query Overview dialog is the place where you may:

·     Review or change your record filter.

·     Select which fields to show in the query output.

·     Select what type of report or output to generate.

·     Pick a record sorting order.

·     Run your query and generate your query output.

To access this dialog, highlight a query in the Query List Manager and press Select

Button

Action

Description

Displays the Filter Building dialog.

Lets you set the conditions that the records must meet to be included in the query results (e.g. only those customers in New York). (See The Filter Building Dialog.)

Displays the Type of Output dialog.

Lets you select what format OT2 Query Maker should use for your query results (report, table, worksheet, etc.) (See Selecting the Type of Output.)

Displays the Select Fields to Show in Query dialog.

Allows you to select which fields OT2 Query Maker will include in the query results (See Selecting Fields to Show in Query.)

Displays the sort order dialog which lets you specify how OT2 Query Maker will sort the records that are included in the query.

You can specify up to 9 fields to sort the results on.

(See Picking the Record Sort Order.)

If you check this option, then after pressing the Run Query button, you will see the query results in an on-screen table before OT2 Query Maker outputs to your chosen output type.  

When done browsing, you can continue by mouse clicking the window's close box or by pressing the Esc key. 

After exiting the browse window, you will be asked if you wish to proceed.

This allows you to check your work before you generate a report or output file.

Eliminates duplicate records from the result.

A duplicate record is a record where every field matches every field in another record. When you check this box, OT2 Query Maker will create a result set with only one instance of such records.

·      This option makes for smaller result sets, but increases query processing time.

Displays descriptive help text.

Prepares and displays query results.

Selects the records that match the filter conditions you specified and either shows you these results in a browse window (if the above described Browse query results is checked) or directly generates the output type you requested (e.g. report, text files, spreadsheet).

Exits from dialog.

Saves all of your changes and returns you to the Query List Manager.