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

Table in database to apply filtering

Output Ports

Table in the database with filtered rows

Best Friends (Incoming)

• DB Table Selector (32 %) 
• DB Row Filter (26 %) 
• DB Joiner (19 %) 
• DB Connection Table Writer (6 %) 
• Table Row to Variable (3 %) 
• Show all 9 recommendations

Best Friends (Outgoing)

• DB Reader (41 %) Streamable
• DB Joiner (27 %) 
• DB Row Filter (18 %) 
• DB Query (9 %) 
• DB Sampling (2 %) 
• Show all 6 recommendations

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.