FlowmageDocs

Filter

Keeps only the rows that match your conditions.

Settings

SettingWhat it is
RowsThe list to filter.
MatchWhether every condition must hold, or one match is enough.
ConditionsNo conditions keeps every row. Numbers compare as numbers, ISO dates as dates, everything else as text.
Technical details
KeyValue
rowsany JSONits `{{ }}` must give an array
combine"and" or "or", by default "and"
conditionslist of {field: text, operator?: "equals" or "notEquals" or "contains" or "notContains" or "startsWith" or "endsWith" or "greaterThan" or "greaterOrEqual" or "lessThan" or "lessOrEqual" or "isEmpty" or "isNotEmpty", value?: text}, by default []

Output

FieldType
rowsarray
countRow countnumber
Sample output, and the expression for each field
  • count1
  • rows
    • [0]
      • status"open"

Errors

When a step of this node stops a run, the run page shows a code. Look it up:

Example step

The step as a flow file holds it. Replace each value in <…>.

{
  "config": {
    "combine": "and",
    "conditions": [],
    "rows": "<rows>"
  },
  "label": "Filter",
  "type": "list.filter",
  "version": 1
}