elasticsearch. Combined fields search

Question

Programming

Hello Habr.
I use Elasticsearch to search CouchDB.
The search is carried out by full name. The database has an object with name fields. last, name .first, name.middle.
I'm looking like this:

{
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "query": "Петров Иван Сергеевич",
            "fields": [
              "name.last",
              "name.first",
              "name.middle"
            ]
          }
        }
      ]
    }
  },
  "filter": {},
  "from": 0,
  "size": 20
}

And everything seems to be fine, but when searching, the correspondence to each of the fields is checked in turn.
Those. the result will include all the Petrovs, then all the Ivans, then all the Sergeyevichs.
You need to somehow combine the name fields. last, name .first, name.middle and search on this combined field.
Does anyone know how to do this?

Answer 1

Try something like this:

{
  "query": {
    "bool": {
      "should": [
        {
          "match": {"name.last": "Петров Иван Сергеевич"}
        },
        {
          "match": {"name.first": "Петров Иван Сергеевич"}
        },
        {
          "match": {"name.middle": "Петров Иван Сергеевич"}
        }
      ],
      "minimum_number_should_match": 1
    }
  },
  "filter": {},
  "from": 0,
  "size": 20
}