I have zero luck in getting this work. First of all the engine expects us to create subfields and after we do that the filter query returns empty results.
I followed exactly what is given here and no luck
I have elastic 8.14
Mapping :
{
"mappings": {
"properties": {
"manager": {
"type": "nested",
"properties": {
"age": { "type": "integer" },
"name": {
"properties": {
"first": { "type": "text" },
"last": { "type": "text" }
}
}
}
}
}
}
}
Data :
{
"manager": [
{
"name": {
"first" : "John",
"last" : "Smith"
}
},
{
"name": {
"first" : "Alice",
"last" : "White"
}
}
]
}
Query :
{
"query": "",
"filters": {
"manager.name.first": "Alice"
}
}
Result : is empty