Maintaining the Selection Condition for a View

Once you have defined the base tables and fields of the view, you can restrict the number of records contained in the view by defining a selection condition.

  1. Select the function Goto ® Selection condition in the field maintenance for the view.

    2. The maintenance screen for selection conditions appears.

  2. You can enter a selection condition of the form

    3. Table Field name Operator Comparison value AND/OR

    in every line.

    The entries have the following meaning:

    - Table: Name of the base table from which the field was taken.

    - Field name: Name of the field for which the selection condition was formulated.

    - Operator: Comparison operator for the selection condition. The following operators are permitted: GT (greater than), GE (greater than or equal to), NE (not equal to), EQ (equal to), LT (less than), LE (less than or equal to), LIKE and NOT LIKE.

    - Comparison value: Constant value with which the field value is compared. Text literals, which must be enclosed in apostrophes, and numbers are permitted as comparison values, depending on the data type of the field.

    - AND/OR: Link between two lines of the selection condition. OR operations are only permitted between lines which refer to the same field. Note that OR has a higher priority than AND. The condition <BED1> AND <BED2> OR <BED3> is therefore interpreted as <BED1> AND (<BED2> OR <BED3>).

    A list of all the fields of a table can be obtained by positioning the cursor on the corresponding table names and choosing Edit ® Choose fields. A dialog box appears. Select the fields to be included in the first column and choose Copy.

  3. Save your entries for the selection condition(s).

You can formulate selection conditions for all the fields of the base tables included in the view. It is not important whether or not these fields were included in the view.