And of array items in terms query

Elastic Stack Elasticsearch
1

Hi, I need to know that whether an AND functionality of terms query exists or not?
For example -

{
  "terms": {
     "color": [
        blue, 
        red, 
        black
     ]
  }
}

The above query will return all the documents having any of the three colors but I want only those documents having all the three colors.
I already know a way to combine boolean and match query but is there any way where I can pass the whole array like terms query to get the desired result.
Thankyou!

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.