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, Oct 19 '22 at 12:50
@Shawan I have updated my answer based on mapping you have provided. Please check it. — Sagar Patel, Oct 19 '22 at 13:30

Sagar Patel · Accepted Answer · 2022-10-19T13:30:09.390

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 '22 at 13:30

answered Oct 19 '22 at 13:18

Sagar Patel

4,993
1
8
19

Wondering why we need the `.keyword` to make it works? Also, both match and term are in `must` not should? – Shawn Yeung Oct 19 '22 at 13:36
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. – Sagar Patel Oct 19 '22 at 13:39

Elastic search boolean query object array should clause

1 Answers1