Settings
| Setting | What it is |
|---|---|
| Rows | The list to filter. |
| Match | Whether every condition must hold, or one match is enough. |
| Conditions | No conditions keeps every row. Numbers compare as numbers, ISO dates as dates, everything else as text. |
Technical details
| Key | Value |
|---|---|
rows | any JSONits `{{ }}` must give an array |
combine | "and" or "or", by default "and" |
conditions | list 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
| Field | Type |
|---|---|
rows | array |
countRow count | number |
Sample output, and the expression for each field
- count1
- rows
- [0]
- status"open"
- [0]
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
}