multi_filter
Filter arrays of JSON objects using multiple conditions combined with AND/OR logic, so you can isolate only the records that match your query criteria.
Instructions
Filter an array of objects with multiple conditions combined by AND/OR.
Each condition is a dict with keys: field, operator, value. Operators: eq, neq, gt, gte, lt, lte, contains, regex.
Examples:
[{"field": "status", "operator": "eq", "value": "active"}, {"field": "score", "operator": "gt", "value": 80}]
mode="and" means ALL conditions must match.
mode="or" means ANY condition can match.
Args: alias: The alias of the loaded document. path: Dot-notation path to the array of objects. conditions: List of condition dicts. mode: "and" or "or" (default "and").
Returns: The filtered objects with a match count header.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | and | |
| path | Yes | ||
| alias | Yes | ||
| conditions | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |