Creating a Query
This topic
describes how to create a basic query.
To create a query using advanced mode, see Creating a Query with Advanced Mode.
Follow these steps to create a query.- Open Queries.
-
Click (
) to expand the
My Queries context menu then choose the
+ Create New Query option.
The Create New Query dialog appears.
- Enter the Query Name then click Ok. The query name appears in the My Queries list.
-
Click
Define Query.
The Query Builder dialog opens.
- Select a Schema from the drop-down list.
-
Select a Class from the drop-down list.
To create a query with a Where Clause, see Creating a Query with the Where Clause.
To create a query in Advanced Mode, see Creating a Query with Advanced Mode.
- To add another Class, click + New then select a Schema and Class from the drop-down list. The Class is added to the query.
- Repeat step 7, to add more new classes.
- (Optional) To delete a Class, first select the Class and then click Remove.
- (Optional) To move a Class one position up in the hierarchy, first select the Class and then click Up.
- (Optional) To move a Class one position down in the hierarchy, first select the Class and then click Down.
- When you are finished, click Save. The query is generated based on the parameters you have specified, and the qualifying records appear in grid format.