Filter document on items in an array ElasticSearch using condition AND

Question

I have data:

[
  {
    "NAME": "John Doe", 
    "CLASS":[1,10,30]
  },
  {
    "NAME": "Albert",
    "CLASS": [1,10,40]
  },
  {
    "NAME": "XINN",
    "CLASS": [10,30]
  },
  {
    "NAME": "UJANG",
    "CLASS": [1,40]
  },
  {
    "NAME": "BAMBANG",
    "CLASS": [30,40]
  }
]

I have the following query DSL:

{
  query: {
    terms: {
      class: [1,10]
    }
  }
}

and I want what will appear is:

[{"NAME": "John Doe","CLASS":[1,10,30]},{"NAME": "Albert","CLASS": [1,10,40]}]

How do I change my search to match the result?

score 0 · Answer 1 · answered Sep 15 '21 at 11:53

You need to combine multiple term queries in must clause.

Query

{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "CLASS": {
              "value": 1
            }
          }
        },
        {
          "term": {
            "CLASS": {
              "value": 10
            }
          }
        }
      ]
    }
  }
}

Result

"hits" : [
      {
        "_index" : "index34",
        "_type" : "_doc",
        "_id" : "2EdK6XsBP61bDf9bI3R1",
        "_score" : 2.0,
        "_source" : {
          "NAME" : "John Doe",
          "CLASS" : [
            1,
            10,
            30
          ]
        }
      },
      {
        "_index" : "index34",
        "_type" : "_doc",
        "_id" : "2UdK6XsBP61bDf9bMHT5",
        "_score" : 2.0,
        "_source" : {
          "NAME" : "Albert",
          "CLASS" : [
            1,
            10,
            40
          ]
        }
      }
    ]

Filter document on items in an array ElasticSearch using condition AND

1 Answers1