Elasticsearch query to get array size

Question

I have Elasticsearch documents look like:

Doc 1:
{
  "name" : "Tom",
  "values" : [
    { "value" : "value 1" },
    { "value" : "value 2" },
    { "value" : "value 3" }
  ]
}

Doc 2:
{
  "name" : "Bob",
  "values" : [
    { "value" : "value 1" },
    { "value" : "value 2" }
  ]
}

How can I query by docs which the values array size is larger than 2?

A better approach would be this one: stackoverflow.com/questions/53113822/… (hint: have another field containing the size of the array) — Val
– Val, Commented Aug 13, 2020 at 3:33

Gibbs · Accepted Answer · 2020-08-13 03:05:28Z

1

You need to add this to your bool query.

"filter" : {
    "script" : {
        "script" : "doc['values'].values.size() > 2"
    }
}

filter filters the document which matches the condition.

size() returns the size of the array.

doc['values'] looks for values field.

answered Aug 13, 2020 at 3:05

Gibbs

23.1k14 gold badges84 silver badges148 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch query to get array size

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related