Defining Conditions

Use

You can formulate conditions in the query designer to make data analysis more efficient. In the results area of the query, the data is filtered according to the conditions so that only the part of the results area that you are interested in is displayed.

For more information about the features of conditions, seeConditions.

Procedure

In the Conditions screen area, choose New Conditions in the context menu. The entry with the default text Condition <Number> appears and you edit the description directly.
In the context menu, choose Edit. The conditions editor appears. Its tab pages display the relevant information for defining the condition.

Note

You can also call the conditions editor from the Properties screen area by choosing the Edit pushbutton.
Make the required settings for the definition of the condition. For more information, seeDefinition of Conditions
```
s
```
.
Choose OK. You return to the query definition.
Choose Save Query.

Removing Conditions from Queries

In the Conditions screen area, select the relevant condition and choose Remove in the context menu.
Choose Save Query.

Result

You have defined or changed a condition for a query. Execute the query. Only those objects that fulfill the defined conditions are displayed.