Using
queries
Queries are maintained using the Query list window. The Query list window is used to list available queries for most object types. From the window, queries can be created, changed, viewed, copied, and deleted. They can also be executed there. Executing a query, sometimes called "running" a Query, causes a list window to be opened. The list window executes the selected query and displays the results. The Query list window is displayed by selecting the Open Query List function on the File menu.
Creating
queries
The Query list window is used to list, maintain, and create queries.
The following steps describe how to create a query.
- Open the Query list
window by selecting Open Query List from the File menu.
- Click
the New button. This opens the Query editor.
- In
the Query editor, do the following:
- Type
a name for the query in the Query Name field.
- Type
a description in the Description field.
- Select
Public, Protected, or Private to indicate how you want to share the
query.
- Click
Next. This opens the Selected Column Information
window.
- In
the Selected Column Information window, select the columns that you want
in the query, then click Next. The Sort Information window
appears.
- In
the Sort Information window, indicate how you want the information
sorted, then click Next. The Selection Criteria window
appears.
- In
the Selection Criteria window, specify the filter conditions you want to
use to limit the results of the query, then click Finish.
Now, you can run the query.
Running
queries
Queries can be executed from the Query list window.
The following steps describe how to run a query.
- Open the Query list
window by selecting Open Query List from the File menu.
- In
the Query list window, make the following selections:
- From
the Functional Area drop-down list, select the functional area for the
query you want to run. The object types associated with the selected
functional area appear in the Object Type list. The functional area
choices are: Mapping, XML, EDI, Record Oriented DAta, or Message
Log.
- Select
the object type from the Object Type list. The queries defined for the
selected object type appear in the Queries field.
- In
the Queries field, select the query you want to run.
- Click
Run.
