Filter List V2
Filters a list of JSON objects by comparing a field value against a target using a chosen operator. Supports 11 comparison modes including text, numeric and date-based checks.
What it does
- Takes a list of objects and a JSON path pointing to the field to compare.
- Applies the chosen comparison operator against the provided value.
- Returns only the objects that satisfy the condition, along with the result count.
Notes
- Supports floating-point and date comparisons (unlike V1 which is limited to string/integer).
- The
younger/olderoperators treat the JSON path value as a date and the comparison value as a number of days. distinctreturns items with unique values at the given path (no comparison value needed).- Case Sensitive only applies to
equals,not equals,contains, andnot containsoperators.
Inputs
| Name | Type | Description |
|---|---|---|
| Items to Filter | List | List of JSON objects to filter |
| JSON Path | String | Path to the field within each object (e.g. order.status). For younger/older, this should point to a date field |
| Comparison Operator | String | One of: equals, not equals, contains, not contains, distinct, bigger, smaller, not bigger, not smaller, younger, older |
| Comparison Value | String | Value to compare against. Not used for distinct. Number of days for younger/older |
| Case Sensitive | Boolean | Whether string comparisons are case-sensitive |
Outputs
| Name | Type | Description |
|---|---|---|
| Success | Boolean | Whether the filter ran successfully |
| Filtered List | List | Objects that satisfy the comparison |
| Number of Items | Number | Count of items in the filtered list |