General Steps for Querying the Database

When you query the database, you are searching for ARs that meet a specific set of criteria. The following describes the general steps you use to query the database.

Querying the database

Open a Query window by selecting Open Query from the File menu. (You can also open a Query window by selecting the Open Query tool bar icon or by typing Ctrl+O).

The Select Schema - Query dialog box appears as shown below:

Figure: Select Schema - Query Dialog Box

Select the schema you want to work with by selecting the schema name in the Schema Name list and then selecting the OK button, Return/Enter key, or by double-clicking on the schema name. By default, the last schema used is selected when the Select Schema - Query dialog box appears.

Like other Windows applications, you can use the up and down arrow keys and the Page Up and Page Down keys to display different portions of the Schema Name list.

Define the query criteria to be applied to the search by filling in fields in the Query window or by using the query bar. (The query bar is an area at the bottom of the Query window that allows you to easily "build" complex query criteria.) See the next section, Defining Query Criteria, for more detailed information.
Select the operation that you want to perform on the ARs from the Query menu or by selecting an icon from the tool bar. (Not all actions are available from the tool bar.) See Query Operations for more detailed information.

[Top] [TOC] [Prev] [Next]

support@remedy.com