How to use nested query filter?

[akhmadnurmuhammad]

Hi all,

how to make nested query filtering parent based on nested child object, also filter the child to, something query like this?

{
    "query": {
        "bool": {
            "must": [
                {
                    "range": {
                        "date": {
                            "lt": "2018-07-05T10:00:00.000Z"
                        }
                    }               
                },
                {
                    "nested": {
                        "path": "child",
                        "query": {
                            "bool": {
                                "must_not": {
                                    "term": {
                                        "child.foo": 0
                                    }       
                                }
                            }
                        }
                    }
                }
            ]
        }
    }
}

thank in advice

[Shegl]

Hi all,

how to make nested query filtering parent based on nested child object, also filter the child to, something query like this?

{
    ....
}

thank in advice

Hello, Did you find a solution ?