Elastic search boolean query object array should clause

Question

Given doc: books

[
 {
  name: "book a",
  authors: 
  [
   {
    name: "John",
   }
   {
    name: "Paul"
   }
  ]
 },
 {
  name: "book b",
  authors: 
  [
   {
    name: "Paul"
   }
  ]
 }
]

Goal: Return the book which match name = book a AND match one of the author name with authors.name = John.

What I tried:

      "must": [
        {
          "bool": {
            "should": [
              {
                "bool": {
                  "must": [
                    {
                      "term": {
                        "name": {
                          "value": "book a"
                        }
                      }
                    },
                    {
                      "bool": {
                        "should": [
                          {
                            "term": {
                              "authors.name": {
                                "value": "John"
                              }
                            }
                          }
                        ]
                      }
                    }
                  ]
                }
              }
            ]
          }
        }
      ]

mapping name: text authors: dynamic

book a and book b is part of single elasticsearch document or seperate document in elasticsearch index. — Sagar Patel
– Sagar Patel, Commented Oct 19, 2022 at 12:50
@Shawan I have updated my answer based on mapping you have provided. Please check it. — Sagar Patel
– Sagar Patel, Commented Oct 19, 2022 at 13:30

Sagar Patel · Accepted Answer · 2022-10-19 13:30:09Z

1

You can use below query:

Please note that, if you are using dynemic mapping of elasticsearch then used name.keyword and authors.name.keyword. otherwise use name and authors.name if you have specified your custom mapping.

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "name": "book a"
          }
        },
        {
          "term": {
            "authors.name.keyword": {
              "value": "John"
            }
          }
        }
      ]
    }
  }
}

edited Oct 19, 2022 at 13:30

answered Oct 19, 2022 at 13:18

Sagar Patel

5,5161 gold badge11 silver badges23 bronze badges

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

2 Comments

Shawn Yeung Over a year ago

Wondering why we need the .keyword to make it works? Also, both match and term are in must not should?

Sagar Patel Over a year ago

You need .keyword because term query work with keyword type of field only and it will look for exact match. Also, it is required in must because you have mentioned to match as AND. If you specify as should then atleast on condition match then result will be return.

Collectives™ on Stack Overflow

Elastic search boolean query object array should clause

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related