Skip to main content

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​

PortTypeTakes
intableone edge

Parameters​

ParameterKindDefaultChoices
modemenu"compare"compare, match, expression
columncolumn""
opmenu">">, >=, <, <=, ==, !=
valuefloat0
texttext""
negatetogglefalse
expressionexpr"true"

Outputs​

PortType
outtable

Details​

  • Category: Rows
  • Operator: filter

Older projects​

Projects saved before documents used operator classes. These convert to filter when they open: DataFilterExtensionOp, FilterOp.