I need to convert the following nested query and aggregations as written in Kibana to bodybuilder.js syntax.
Have tried to write the query. but, don't know how to use the sub aggregation with filters as used in the below query.
{
"query": {
"nested": {
"path": "events",
"query": {
"bool": {
"filter": [
{
"terms": {
"events.id": [
1,
2
]
}
}
]
}
},
"inner_hits": {}
}
},
"aggs": {
"events.name12": {
"nested": {
"path": "events"
},
"aggs": {
"inner": {
"filter": {
"terms": {
"events.id": [
1,
2
]
}
},
"aggs": {
"events.name": {
"terms": {
"field": "events.name"
}
},
"events.name_count": {
"cardinality": {
"field": "events.name"
}
}
}
}
}
}
},
"size": 20,
"_source": [
"email",
"company_name",
"events"
]
}
Is there any tool for this to convert it? Any help.