java - how to use terms query in elasticsearch 7.x in this case

Question

elasticsearch version is 7.x

here has some nested data blow :

data1:
[{name:"tom"},{name:"jack"}]

data2:
[{name:"tom"},{name:"rose"}]

data3:
[{name:"tom"},{name:"rose3"}]
...

dataN:
[{name:"tom"},{name:"roseN"}]

when i use the terms query , I just want to search tom, jack, But don't want to include rose...roseN

query:{
terms:{["tom","jack"]}
}
this code is not effective

question from:https://stackoverflow.com/questions/65838516/how-to-use-terms-query-in-elasticsearch-7-x-in-this-case

Answer 1

Adding a working example

Index Data:

PUT /_doc/1
{
  "names": [
    {
      "name": "tom"
    },
    {
      "name": "jack"
    }
  ]
}

PUT /_doc/2
{
  "names": [
    {
      "name": "tom"
    },
    {
      "name": "rose"
    }
  ]
}

Search Query:

    {
  "query": {
    "bool": {
      "must": {
        "terms": {
          "names.name": [
            "tom",
            "jack"
          ]
        }
      },
      "must_not": {
        "match": {
          "names.name": "rose"
        }
      }
    }
  }
}

Search Result:

"hits": [
      {
        "_index": "65838516",
        "_type": "_doc",
        "_id": "1",
        "_score": 1.0,
        "_source": {
          "names": [
            {
              "name": "tom"
            },
            {
              "name": "jack"
            }
          ]
        }
      }
    ]