Filter nested list of dictionaries

[kemeris2000]

I can't figure out how to select list items which "options" array contains dictionary with name="Option1" and value="100".
Thank you in advance

[
    {
        "id": 1,
        "name": "Item1",
        "options": [
            {
                "id": 104,
                "name": "Option1",
                "value": "100"
            },
            {
                "id": 105,
                "name": "Option2",
                "value": "200"
            }
        ]
    },
    {
        "id": 2,
        "name": "Item2",
        "options": [
            {
                "id": 104,
                "name": "Option1",
                "value": "300"
            },
            {
                "id": 105,
                "name": "Option2",
                "value": "400"
            }
        ]
    }
]

expected result is:

[
    {
        "id": 1,
        "name": "Item1",
        "options": [
            {
                "id": 104,
                "name": "Option1",
                "value": "100"
            },
            {
                "id": 105,
                "name": "Option2",
                "value": "200"
            }
        ]
    }
]

[Gervwyk]

I have not tested it, but try this:

_mql.aggregate:
  on:
    _state: my_data
  pipeline:
     - $match:
         $expr:
            $gt:
              - $size:
                  $filter:
                     input:
                       $options
                     cond:
                       $and:
                          - $eq: 
                            - $$this.name
                            -  Option1
                          - $eq:
                             - $$this.value
                             - '100'
               - 0

[kemeris2000]

Awesome Gervwyk, it does work.

By the way, the most flexible JSON processor I am aware of is jq. I use it on linux systems.
I have't tried it, but there is JavaScript implementation of the jq query language.

[Gervwyk]

Very cool. I did not know about jq. will check it out looks very convenient. If there is a js version, you could easily create an operator function for it. It would be great to also support it.

[kemeris2000]

Correct link to jq JavaScript