How to correctly form a search query in Elasticsearch?

Question

Web development

Hello!
Please help me to correctly form a search query in elastic.
There is an index for products
localhost:9200/test_index/product
Here is the mapping:

{
  "test_index" : {
    "mappings" : {
      "product" : {
        "properties" : {
          "category" : {
            "type" : "integer"
          },
          "id" : {
            "type" : "integer"
          },
          "name" : {
            "type" : "string",
            "index" : "not_analyzed"
          },
          "property_stock" : {
            "type" : "integer"
          },
          "skus" : {
            "type" : "string",
            "index" : "not_analyzed"
          },
          "tags" : {
            "properties" : {
              "group_id" : {
                "type" : "integer"
              },
              "tag_id" : {
                "type" : "integer"
              }
            }
          },
          "visible" : {
            "type" : "boolean"
          }
        }
      }
    }
  }
}

How to make a search request if, for example, you need a product to be included in at least one of the categories (for example, [111, 222, 333, 444]) and it had tags { "group_id": 10, "tag_id": 20} and { "group_id": 50, "tag_id": 100} at the same time.
Thanks in advance!

Answer 1

I myself will answer my own question :-)
I managed to do it in this way:

{
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": [
            {
              "bool": {
                "must": [
                  {"term": {"tags.group_id": 818}},
                  {"term": {"tags.tag_id": 223}}
                ]
              }
            },
            {
              "bool": {
                "should": [
                  {"term": {"categories": 9110}},
                  {"term": {"categories": 9111}},
                  {"term": {"categories": 9114}},
                  {"term": {"categories": 9109}}
                ]
              }
            }
          ]
        }
      }
    }
  }
}