Visual Designer

Filter Node

Configuration

Select a column, an operator, and a value.

Supported operators

OperatorMeaning
=Equals
Not equals
> < Greater/less than (or equal)
containsSubstring match (compiles to LIKE)
in / not inValue is/isn't in a list
is empty / is not emptyNull check

Compiled SQL

Values are always passed as query parameters, never concatenated into the query string. See How DataQloo compiles workflows to SQL for detail.

Limits

One Filter node holds one condition. Combining multiple conditions (AND/OR) in a single node is on the roadmap.