# App search engine nested filter not working

**URL:** <https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864>\
**Category:** Elasticsearch\
**Created:** [June 22, 2024, 1:13am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864 "2024-06-22T01:13:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gautham.pushpakumar](https://avatars.discourse-cdn.com/v4/letter/g/47e85d/32.png) [@gautham.pushpakumar](https://discuss.elastic.co/u/gautham.pushpakumar)\
**Post date:** [June 22, 2024, 1:13am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/1 "2024-06-22T01:13:07Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/6/8/682ec46855ab8fbc39d5f08aa812aaac4cf74244.png)

> **[Elasticsearch index engines | App Search documentation \[8.14\] | Elastic](https://www.elastic.co/guide/en/app-search/current/elasticsearch-engines.html#elasticsearch-engines-supported-fields)**

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

---

<div class="post-metadata">

**Author:** ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)\
**Post date:** [June 24, 2024, 2:54pm UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/2 "2024-06-24T14:54:04Z")

</div>

Hi @gautham.pushpakumar,

Would something like what's [described in this post](https://discuss.elastic.co/t/nested-field-in-app-search/252233/2) work for you?

---

<div class="post-metadata">

**Author:** ![gautham.pushpakumar](https://avatars.discourse-cdn.com/v4/letter/g/47e85d/32.png) [@gautham.pushpakumar](https://discuss.elastic.co/u/gautham.pushpakumar)\
**Post date:** [June 25, 2024, 7:20am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/3 "2024-06-25T07:20:14Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/6/8/682ec46855ab8fbc39d5f08aa812aaac4cf74244.png)

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [June 25, 2024, 8:33am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/4 "2024-06-25T08:33:15Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![gautham.pushpakumar](https://avatars.discourse-cdn.com/v4/letter/g/47e85d/32.png) [@gautham.pushpakumar](https://discuss.elastic.co/u/gautham.pushpakumar)\
**Post date:** [June 25, 2024, 8:44am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/5 "2024-06-25T08:44:08Z")

</div>

Search results are empty.

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [June 25, 2024, 9:35am UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/6 "2024-06-25T09:35:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![gautham.pushpakumar](https://avatars.discourse-cdn.com/v4/letter/g/47e85d/32.png) [@gautham.pushpakumar](https://discuss.elastic.co/u/gautham.pushpakumar)\
**Post date:** [June 25, 2024, 4:57pm UTC](https://discuss.elastic.co/t/app-search-engine-nested-filter-not-working/361864/7 "2024-06-25T16:57:06Z")

</div>

updated with mapping , data and query details