Skip to main content
Version: 5.6

Filters and Filter Groups

Several Snowflake objects use the same filter tab to narrow down which records are processed. It has the same structure across all objects and is used by the transfer objects Snowflake Select, Snowflake Update, and Snowflake Delete, as well as by the triggers Snowflake Transfer Status Trigger and Snowflake Data Change Trigger.

Dialog Overview​

Filter tab of a Snowflake object with two filter criteria

Filters and filter groups are created graphically. At runtime, the OPC Router generates the appropriate filter condition from the tree. Use the Add button to add a single filter criterion and Add Group to add a filter group. The button with the minus sign deletes the respective criterion or group.

Structure of a Filter​

A filter consists of three elements:

  • Column: The column to which the filter applies.
  • Filter operator: Determines how the filter value is used to filter the records.
  • Filter value: The value used for filtering.

An explanation of the various filter operators can be found under Database Filter Operators.

Combining with AND and OR​

Clicking on the text AND or OR switches the group type to the other.

  • AND: All conditions in the group must be met for the group as a whole to be true.
  • OR: At least one condition in the group must be met for the group as a whole to be true.

Fixed and Dynamic Filter Values​

  • In transfer objects (Select, Update, Delete), filter values can be dynamically populated at runtime via connection arrows or specified at design time.
  • In triggers, filter values are entered statically.