Filter Examples (In Database) (In-Database Processing)


Keeps only those rows that satisfy a certain criteria.


This operator filters the set of rows based on the criteria defined either by an expression (where you can use your database-specific functions as well), or by a combination of simple expressions. A dialog that you can access by clicking on the appropriate button helps in both cases.

When constructing the filter expression, you may find the built-in macros like process_start_db and t_db useful. Please check the Nest operator help for more information.


  • example set input


  • example set output


  • condition_class Implementation of the condition. Range: selection
  • filters Defines the list of filters to apply. Range: other
  • parameter_expression Parameter string for the expression, e.g. 'attribute1 = attribute2'. Put identifiers containing reserved keywords or special characters into square brackets ([]). The square brackets will be replaced by database specific escaping characters (e.g. backticks(`) for Google BigQuery). Uncheck the 'replace square brackets' parameter to disable replacement. Range: string
  • replace_square_brackets Replace square brackets. By default square brackets are replaced by the database specific characters used for escaping special identifiers (e.g. with backticks(`) for Google BigQuery). In some situations you may not want to replace the square brackets in the expression. Uncheck this parameter to do so. Range: boolean
  • filters_list The list of filters. Range: list
  • filters_logic_and Logic operator for filters. Range: boolean
  • filters_check_metadata Check meta data for comparators. Range: boolean