DB Row Filter

This node allows rows to be filtered from the input DB Data table so that the resulting DB Data table will only contain the rows that match the specified filter criteria.
Within the dialog, an SQL WHERE clause is interactively created by adding and connecting filter criteria.

Options

Match row if matched by
Match the row if all or any criteria match:
  • All criteria: a row is matched if all of the criteria match (intersection of matches)
  • Any criterion: a row is matched if at least one of the criteria matches (union of matches)
Filter criteria
The list of criteria that should be filtered on.
  • Filter column: The column on which to apply the filter.
  • Operator: Select the filter operator to apply.
  • Filter value: The value to compare the column against. The type of input depends on the selected column's data type.

Input Ports

Icon
DB Data to apply filtering.

Output Ports

Icon
DB Data with matching rows.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.