Elasticsearch 5 | filter nested object and nested aggregation count

Question

elasticsearch 5.2

I want to filter my items by the nested object state.id = 101 and an aggregation count for all the items by state.id. There are items with the state ids 101, 102 and 103.

The aggregation count is now limited to state.id 101. I want the only get the items with state.id = 101 and the aggregation count for all state ids.

How can i do this?

GET index/items/_search
{
  "query": {
        "nested" : {
            "path" : "state",
            "query": {
              "bool": {
                "filter": {
                  "term": { "state.id": 101 }
                }
              }
            }
        }
  },
     "aggs" : {
        "state" : {
            "nested" : {
                "path" : "state"
            },
            "aggs" : {
                "count" : { "terms" : { "field" : "state.id" } }
            }
        }
    }
}

Val · Accepted Answer · 2017-02-11 15:38:18Z

2

You need to use post_filter instead of query: (Oh and use POST instead of GET when sending a payload)

POST index/items/_search
{
   "post_filter": {                         <--- change this
      "nested": {
         "path": "state",
         "query": {
            "bool": {
               "filter": {
                  "term": {
                     "state.id": 101
                  }
               }
            }
         }
      }
   },
   "aggs": {
      "state": {
         "nested": {
            "path": "state"
         },
         "aggs": {
            "count": {
               "terms": {
                  "field": "state.id"
               }
            }
         }
      }
   }
}

If you want to further narrow the nested aggregation, you can also add a filter:

POST index/items/_search
{
   "post_filter": {
      "nested": {
         "path": "state",
         "query": {
            "bool": {
               "filter": {
                  "term": {
                     "state.id": 101
                  }
               }
            }
         }
      }
   },
   "aggs": {
      "narrow": {
         "filter": {
            "nested": {
               "path": "state",
               "query": {
                  "bool": {
                     "filter": {
                        "term": {
                           "state.id": 101
                        }
                     }
                  }
               }
            }
         },
         "aggs": {
            "state": {
               "nested": {
                  "path": "state"
               },
               "aggs": {
                  "count": {
                     "terms": {
                        "field": "state.id"
                     }
                  }
               }
            }
         }
      }
   }
}

edited Feb 11, 2017 at 15:38

answered Feb 11, 2017 at 5:44

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Joost Over a year ago

Thanks. Exactly what I needed. One more question. I want to narrow down the current aggregation context to a specific set of documents. How can i use filter aggregation in an nested an aggregation. link

Joost Over a year ago

Thx. But, I want to filter the aggregation on the nested object. ``` "filter": { "terms": { "state.id": [101,102] } }, ``` And only get the documents from "state.id": 101 like above.

Val Over a year ago

You simply need to replace the filter with the nested one. I've updated my answer

Joost Over a year ago

Exactly what I needed. Through your answers, I understand aggregations much better now. Thx.

Collectives™ on Stack Overflow

Elasticsearch 5 | filter nested object and nested aggregation count

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related