Adding a filter rule

  1. Select the group where a new rule must be added.
  2. Click ADD FILTER RULE.
    A new blank line is created.
  3. Select the column from the drop-down 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).