我试图根据一些标签和子类别过滤文档。

部分文档：

[{
    "_id" : "2oukjh8o9qy2ejhasdkqwe",
    "productName" : "ASSORTED DOUGHNUT 1PC",
    "productSubCategory" : [
        {
            "label" : "Veg",
            "imageUrl" : "/catImg/fandA.svg"
        }
    ],
    "isVisible" : true,
    "tags" : [
        {
            "tagImageUrl" : " ",
            "label" : "Favorites",
            "tag" : "favorites"
        }
    ]
},
{
    "_id" : "638daf9f42e6efc7f06641c2",
    "isVisible" : true,
    "productName" : "FILTER COFFEE",
    "productSubCategory" : [
        {
            "_id" : ObjectId("638daf18ed445826c06a7328"),
            "label" : "Veg"
        }
    ],
    "tags" : [
        {
            "tagImageUrl" : " ",
            "label" : "Trending",
            "tag" : "trending"
        },
        {
            "tagImageUrl" : " ",
            "label" : "Favorites",
            "tag" : "favorites"
        },
        {
            "tagImageUrl" : " ",
            "label" : "Cabin Friendly",
            "tag" : "cabinfriendly"
        }
    ]
},
{
    "_id" : "6389d7f942e6efc7f05d51e0",
    "isVisible" : true,
    "productName" : "ILLY DOPPIO",
    "productSubCategory" : [
        {
            "_id" : ObjectId("638d97236612ca5d5ceb53b9"),
            "label" : "Non-Veg"
        }
    ],
    "tags" : [
        {
            "tagImageUrl" : " ",
            "label" : "Cabin Friendly",
            "tag" : "cabinfriendly"
        }
    ]
}]

正在尝试的查询

{
    "query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "productSubCategory.label": {
                            "query": "Veg",
                            "operator": "and"
                        }
                    }
                },
                {
                    "match": {
                        "isVisible": true
                    }
                }
            ],
            "filter": {
                "terms": {
                    "tags.tag": [
                        "favorites",
                        "cabinfriendly"
                    ]
                }
            }
        }
    }
}

要求

结果文档必须具有查询中提供得任何标记.tag.必须具有isVisible为true与productSubCategory.label，如查询中提供得那样.
与上述查询，我得到非蔬菜项目以及。