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 on the features of conditions, see Conditions.

Procedure

...

       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. This offers the parts of the definition in the tab pages.

       3.      Make the required settings for the definition of the condition. For more information, see Definition of Conditionss.

       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.

Result

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

You can display the condition descriptions in the query view and activate or deactivate them there. See Using Conditions.

 

See also:

 

Background Information on Conditions