Adding a filter rule

  1. Select the group where a new rule must be added.
  2. Click ADD FILTER RULE.
  3. Select the column from the list in the first field.
  4. Select the operator.
  5. Specify a constant value.

    When you select an operator with a value, In or Not in, you can specify multiple values that are separated by the pipeline (|) symbol.

    When you select an operator with a value, Between or Not Between, an additional entry field is displayed. In this field you can specify a second value.

    Values are compared to the source database data types. 

    Values has basic numeric and boolean validations. Plus validation for data time (yyyy-[m]m-[d]d hh:mm:ss[.f...]), date (yyyy-[m]m-[d]d), Microsoft SQL Server small date (yyyy-MM-dd HH:mm).