where_exp

Filters array based on provided condition.

{% json employees %}
  [
    {
      "first_name": "Ann",
      "last_name": "Smith",
      "position": "Accountant",
      "city": "New York",
      "age": 25
    },
    {
      "first_name": "Adam",
      "last_name": "Fox",
      "position": "Salesman",
      "city": "New Jersey",
      "age": 35
    },
    {
      "first_name": "Angela",
      "last_name": "Newman",
      "position": "Accountant",
      "city": "Boston",
      "age": 43
    }
  ]
{% endjson %}
{% assign where_exp_city_result = employees | where_exp: "item", "item.city contains 'New'" %}
{{ where_exp_city_result | log }}

Results in following output:

[
  {
    "first_name": "Ann",
    "last_name": "Smith",
    "position": "Accountant",
    "city": "New York",
    "age": 25
  },
  {
    "first_name": "Adam",
    "last_name": "Fox",
    "position": "Salesman",
    "city": "New Jersey",
    "age": 35
  }
]