Use Query Forms
- Last UpdatedMay 10, 2023
- 3 minute read
The Query Forms enable you to:
-
Find information, using a form-based search mechanism.
-
Further your advanced search through the database.
-
Define criteria and modify it, while executing searches.
-
Generate search results, listing the data related to one or more item in the database.
The following command buttons appear in the Query Form:
|
Selecting |
Enables |
|---|---|
|
|
Executing search based on the criteria selected and entered in the box. |
|
|
Returning to the search criteria used, after the search result appears in the search criteria box. |
|
|
Auto-selecting all the search criteria check boxes. |
|
|
Deselecting all the search criteria check boxes. |
|
|
Clearing a selected search criteria check box. |
The Query Form search results display the following icons:
|
Icon |
Functionality |
|---|---|
|
|
Indicates the existence of multiple search results, related to a search criterion. Selecting this icon enables you to view a list of search results. |
|
|
Indicates clashing search result values, as the search criterion is fetching results of multiple datasets with differing or missing values. Selecting this icon enables you to view a list of datasets containing your search criterion and their respective values. Note: Clashes are case-insensitive. |
|
|
Opens the Summary View of the search result item, corresponding to the search ID. |
|
|
Enables navigating through the search results, beyond the first record of the search result displayed in the search criteria box. Displays the total number of search result records, and the record under viewing in an instance. Selecting the backward arrows enables returning to the previous, or first search result record. Selecting the forward arrows enables navigating to the next, or last search result record. Entering a specific record number in the Item box enables viewing the record instantly in the Query Form. |
