DB Row Filter

This node allows rows to be filtered from the input database table so that the SQL result will only contain the remaining rows.Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.

Options

Conditions
This list contains the conditions.
Add Condition
Add condition to the list. If a logical operator is selected it will be added to that, if a condition is selected it will be added to the parent logical operator.
Group
Create a new logical operator and put the selected condition below.
Ungroup
Delete the selected logical operator and put the conditions from it to the parent logical operator.
Delete
Delete the selected element from the list.

Input Ports

Icon
Table in database to apply filtering

Output Ports

Icon
Table in the database with filtered rows

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.