How to correctly compose a query in ElasticSearch?

Question

elasticsearch

My products are stored in this format in Elastica

{
            "_index": "market",
            "_type": "products",
            "_id": "4",
            "_score": 0.5619608,
            "_source": {
               "id": 4,
               "title": "Zora",
               "category_id": 3,
               "price": "35000.00",
               "characteristicValue": [
                  {
                     "id": 1,
                     "name": "Красный",
                     "characteristic": {
                        "id": 2,
                        "name": "color"
                     }
                  }
               ]
            }
         }

I need to filter by product properties.
In particular, I consider one filter

"query": {
        "bool": {
            "must": [
               {"match": {
                  "characteristicValue.characteristic.name": "color"
               }}
            ],
            "should": [
               {"terms": {
                  "characteristicValue.name": [
                     "красный",
                     "синий"
                  ]
               }}
            ]
            
        }
    }

In this query, everyone who has the color property falls out, but they do not have colors (red or green). How to fix a request?

Answer 1

what should be moved to must
https://www.elastic.co/guide/en/elasticsearch/ref...
If the bool query is in a query context and has a must or filter clause then a document will match the bool query even if none of the should queries match . In this case these clauses are only used to influence the score .