To create a filter with the wizard, first select a column, edit the conditions and comparison operators. Once these settings have been configured, you can apply the filter.

To create and apply a filter with the wizard

1. Click View settings > Open filter wizard.

2. Select the column for the table in the filter wizard.

   1. Click At least one entry exists and specify whether the column should reference or be referenced from other tables.

      The following views are available.

      Table 10: Views in the filter wizard

      View	Description
      Value comparison	Compares the values of the selected columns. These columns are part of the table you want to apply the custom filter to. The advantage of using the WHERE clause wizard is that you can select all the table's columns as opposed to the filter function, which only provides a default selection of columns.
      References to other objects	Creates a n:1 relation. Select the desired table B in this view. Several data records from table A can be assigned to one data record in table B. A data record in table A cannot be assigned more than one data record from table B.
      References for assignment tables	Creates a 1:n relation. Each data record in table A can be assigned to several data records from table B and vice versa. These relations are realized through a third Table for realizing assignment tables Assignment table only contains the foreign keys of the other tables A and B.
      References from other objects	Creates a 1:n relation. Select the desired table B in this view. Several data records from table B can be assigned to one data record in table A. A data record from table B cannot be assigned to more than one data record from table A.

   2. Select the desired column in the Filter wizard view.

      This inserts a control for the first condition.

      Figure 1: Filter wizard with example conditions

      

3. Enter the condition and configure the following settings:

   1. Enter the comparison value.

      You can enter a date, numeric, or text value. The input of the value type depends on the selected column.

   2. Change the comparison operator.

      To change the comparison operator, click the comparison operator "is less than", for example.

      The type of comparison operator depends on the column type. The following comparison operators are available.

      Table 11: Comparison operators

      Value type	operator	Description
      Text value	is equal to	Finds the same text value.
      	Precedes the word in the alphabet	Finds all results that occur before the entered text in alphabetical order.
      	Follows the word in the alphabet	Finds all results that occur after the entered text in alphabetical order.
      	Not equal	Finds all results that are not the same as the entered text.
      	Is contained in	Finds all results that contain the text value.
      	Contains	Finds all results that contain the text value.
      	Begins with	Finds all results that begin with the entered text value.
      	Ends with	Finds all results that end with the entered text value.
      	Is equal or precedes the word in the alphabet	Finds all results that either contain the entered text value or occur before the entered text value in alphabetical order.
      	Is equal or follows the word in the alphabet	Finds all results that either contain the entered text value or occur after the entered text value in alphabetical order.
      Numerical value	Is less than	Finds all results that are smaller than the entered numerical value.
      	Is greater than	Finds all results that are larger than the entered numerical value.
      	is equal to	Finds all results that are the same as the entered numerical value.
      	Is less or equal	Finds all results that are less than or equal to the entered numerical value.
      	Is greater than or equal	Finds all results that are greater than or equal to the entered numerical value.
      	Not equal	Finds all results that are not the same as the entered numerical value.

   3. Change the Boolean value if the option is available in the selected column.

      The value false is selected by default. If you change the value to true, data appears that matches the content of this column.

   4. To negate the defined condition, click applies.

      The condition statement is reversed and the data displayed after filtering, does not match this condition. This setting is not available if the Boolean option can be set.

   5. Use the operators and or or when applying multiple conditions.

      NOTE: Remove the control by clicking .

4. Insert another expression with <<Add expression>> and repeat this step if required.

5. Perform one of the following tasks:

   • Apply the filter by clicking Apply.

     This returns you to the original view where a message alerts you to the active filter wizard.

   • Close the wizard with Close.