A Managing Queries

This appendix contains the following topics:

Appendix A, "Selecting Additional Fields"
Appendix A, "Clearing the Form"

You use Query Management mode to create, modify, and save queries. Click the icon to the right of the Query field to enter Query Management mode. Depending on the value in the Query field when you enter Query Management, the options for a new query or an existing query appear in the Query Management side panel. When you enter Query Management mode, a plus sign on the form designates each field and QBE column that you can select for a query.

A.1 Selecting Additional Fields

You can select a comparison type in the Query Management panel for each field or query-by-example (QBE) column and specify the comparison value in the query. To do so, click the form fields or QBE columns that you want use as search criteria. You can select only the form fields and QBE columns that have a plus sign.

Alternatively, you can use the Additional Fields Selection section to select the form fields or QBE columns. This section displays only the business view (BSVW) columns that are included on the form including the hidden columns. For example, if BSVW includes the columns A, B and C; A is displayed on the form, B is hidden and C is not included, then the Additional Fields Selection section displays A and B columns.

A.2 Clearing the Form

You can clear the values that you have entered on the form. For example, the values entered in the header or QBE column.

To clear the values on the form:

Access a form with the Query control.
Enter any search criteria on the header or the QBE and then, click Find.
Click the Clear Form icon located to the right of the Add, Edit Queries icon. The system deletes the values in the header or the QBE.

Alternatively, you can select Clear form when selected option in the Query Management panel to clear the values on the form automatically when the query is selected.