Defining Conditions

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.

1. 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.
2. 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.

3. Make the required settings for the definition of the condition. For more information, seeDefinition of Conditions

   s

   .
4. Choose OK. You return to the query definition.
5. Choose Save Query.

Removing Conditions from Queries

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

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

See also:

Background Information on Conditions