Filter In-DB Tool

The Filter In-DB tool filters records with a basic filter or with a custom expression using the native language of the database, such as SQL. Use the Filter In-DB tool to query records and return records that meet the specified criteria.

While most In-DB tools do not require SQL commands, this tool requires SQL for more advanced processing.

Configure the tool

  1. Select the appropriate filter type.
  2. Validate expression here at runtime: An option that sends a query to the database to report errors contained in the expression in the results window of this tool.
  3. By default, errors are reported in the results window of downstream tools.


Records that meet the specified criteria are output through the T output anchor. All other records are output through the F output anchor.