👀 Views: 70 💬 Answers: 1 📅 Created: 2025-07-24

elasticsearch aggregations nested filters json

I just started working with I'm stuck on something that should probably be simple. I'm currently working with Elasticsearch 8.5 and I'm working with an scenario with nested aggregations that involve filters. I've defined an index with nested documents representing orders and their line items. My goal is to aggregate the total sales by filtering on specific criteria for the line items. However, the results I'm getting don't match my expectations. For example, when I run the following query, I expect to see a total sales amount filtered by a specific product category: ```json { "query": { "match_all": {} }, "aggs": { "total_sales": { "nested": { "path": "line_items" }, "aggs": { "filtered_line_items": { "filter": { "term": { "line_items.category": "electronics" } }, "aggs": { "total_amount": { "sum": { "field": "line_items.amount" } } } } } } } } ``` When I execute this query, I sometimes see `total_amount` return `0`, even when I know there are relevant line items with the category "electronics". I've checked the data to confirm that there are line items that meet this criterion, and I also verified that the category field is indexed correctly. The mappings for `line_items` are properly set as nested. I've tried several variations of the filter and aggregation structure, including using `top_hits` to debug if the relevant documents are being recognized, but the scenario continues. Additionally, I have confirmed that the index has been refreshed before executing the query. Is there something I'm missing regarding how nested aggregations interact with filters, or do you think there could be an scenario with the way my data is structured? Any insights or suggestions for troubleshooting this behavior would be greatly appreciated. My development environment is Ubuntu. Any help would be greatly appreciated! Am I approaching this the right way?