Nested documents search

gistfile1.txt

Mapping:
{
    "test": {
        "properties": {
            "nested_docs": {
                "properties": {
                    "nested_doc1": {
                        "type": "nested",
                        "properties": {
                            "user_id": {
                                "type": "string",
                                "index": "not_analyzed"
                            },
                            "created_time": {
                                "type": "date",
                                "format": "dateOptionalTime"
                            }
                        }
                    },
                    "nested_doc2": {
                        "type": "nested",
                        "properties": {
                            "user_id": {
                                "type": "string",
                                "index": "not_analyzed"
                            },
                            "created_time": {
                                "type": "date",
                                "format": "dateOptionalTime"
                            }
                        }
                    },
                    "nested_doc3": {
                        "type": "nested",
                        "properties": {
                            "test_id": {
                                "type": "string",
                                "index": "not_analyzed"
                            },
                            "created_time": {
                                "type": "date",
                                "format": "dateOptionalTime"
                            }
                        }
                    },
                    "nested_doc4": {
                        "type": "nested",
                        "properties": {
                            "test_id": {
                                "type": "string",
                                "index": "not_analyzed"
                            },
                            "created_time": {
                                "type": "date",
                                "format": "dateOptionalTime"
                            }
                        }
                    }
                }
            }
        }
    }
}



Filter query that finally works:

{
    "filter": {
        "nested": {
            "path": "nested_docs.nested_doc2",
            "query": {
                "term": {
                    "nested_docs.nested_doc2.user_id": 3
                }
            }
        }
    }
}