Elasticsearch Nested Query matching and/or

Question

For example, I have data containing the following:

{
  author: "test",
  books: [
    {
      name: "first book",
      cost: 50
    },
    {
      name: "second book",
      cost: 100
    }
  ]
}

I want to search the author which has ALL books with cost > 40. How would the query for that look like? The field books is mapped as nested property.

Community · Accepted Answer · 2017-05-23 11:52:55Z

1

For author names with cost of one book greater than 40 (in hits), something as below in query would work

POST http://192.168.0.68:9200/library/Book/_search
{
   "fields": ["author"], 
   "query": {
      "filtered": {
         "query": {
            "match_all": {}
         },
         "filter": {
            "nested": {
               "path": "books",
               "filter": {
                  "range": {
                     "books.cost": {
                        "gt": 40
                     }
                  }
               }
            }
         }
      }
   }
}

For all books having cost greater than 40, I had to handle the collection of nested field manually in client side after getting the response.

Not sure if script applies here to apply filter to all nested objects.

Reference

document not in nested documents elasticsearch

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Sep 3, 2014 at 7:07

prayagupadhyay

31.4k14 gold badges165 silver badges199 bronze badges

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

1 Comment

Ace Dimasuhid Over a year ago

Yep was using that query as well for ANY books greater than 40, which works well. However, ALL seem to be a harder issue. Client side filter would be my last resort though, if it is not at all possible in elastic search. Thanks!

Collectives™ on Stack Overflow

Elasticsearch Nested Query matching and/or

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related