Filter
Keep rows matching a condition. The planner puts it in SQL when that removes real volume.
Syntax
{ "id": "n1", "op": "filter", "name": "filter", "x": 0, "y": 0, "params": {} }
An edge into it ends at "targetPort": "in"; one out of it starts at "sourcePort": "out"; a parameter is set in params (leave out the ones at their default), driven by an edge to par:value, or read elsewhere as ch('filter/value').
Inputs
| Port | Type | Takes |
|---|---|---|
in | table | one edge |
Parameters
| Parameter | Kind | Default | Choices |
|---|---|---|---|
mode | menu | "compare" | compare, match, expression |
column | column | "" | |
op | menu | ">" | >, >=, <, <=, ==, != |
value | float | 0 | |
text | text | "" | |
negate | toggle | false | |
expression | expr | "true" |
Outputs
| Port | Type |
|---|---|
out | table |
Details
- Category: Rows
- Operator:
filter
Older projects
Projects saved before documents used operator classes. These convert to filter when they open: DataFilterExtensionOp, FilterOp.