App search engine nested filter not working

Elastic Stack Elasticsearch
1

image
image888×345 10.4 KB

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

2

Hi @gautham.pushpakumar,

Would something like what's described in this post work for you?

3

thanks @jessgarson

I might have to do Object and Nested approach to keep original json intact for response.

But wondering why will they mention in documentation that filters will work

image
image888×345 10.4 KB

4

Hi @gautham.pushpakumar,

Thanks for the details you've provided so far. What do you mean by it doesn't work? Are you seeing a particular error? Or are the results not what you expect?

5

Search results are empty.

6

Ok, can you share the filters you have specified along with the index mapping and sample documents you expect to match?

7

updated with mapping , data and query details