Elasticsearch count elements in array, for a property having a value

Question

I have a document with structure like this:

{
  "products": [
    {
      "variants": [
        {
          "type": "type_1"
        },
        {
          "type": "type_2"
        }
      ]
    }
  ]
}

"variants" are dynamic mapping. I want to count variants having a particular type. If i use terms aggregation it will return me bucket keys of all types and their respective doc count but i want types that i pass to be present in the bucket keys and their respective doc count.

Or is their any way to only count variants instead of doc and get buckets with type as key and value as their count

Can anybody please help me with the query?

@anmaxvl Yes but i still get other types in bucket keys. I only want types that i pass to be present in the bucket keys and their doc count — Kiba
– Kiba, Commented Dec 14, 2018 at 2:38

Kiba · Accepted Answer · 2018-12-14 17:14:41Z

2

I solved it using script.

{
  "aggs": {
    "agg_terms_types": {
      "terms": {
        "script": {
          "source": "params.selected_types",
          "params": {
            "selected_types": [
              "type_1"
            ]
          }
        }
      }
    }
  }
}

edited Dec 14, 2018 at 17:14

answered Dec 14, 2018 at 14:58

Kiba

4091 gold badge6 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch count elements in array, for a property having a value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related