按字段和值过滤弹性搜索结果

Question

我有一个样本数据，其中包括来自大学、学校和宿舍的数据。 我想在 Elasticsearch 中使用这些数据。在进行过滤时，我按如下方式发送正文：

示例数据：

[
    {
        name: 'Maisha school of sience',
        school_type: 'public',
        location: 'A',
    },
    {
        name: 'Maisha elementry school',
        school_type: 'private',
        location: 'B',
    },
    {
        name: 'istanbul university',
        university_type: 'public',
        location: 'C',
    },
    {
        name: 'Maisha university',
        university_type: 'private',
        location: 'D',
    },
    {
        name: 'kbb center of Maisha',
        dormitory_type: 'public',
        location: 'E',
    },
    {
        name: 'high Maisha dorm',
        dormitory_type: 'private',
        location: 'F',
    },
]

我的查询：

"query": {
        "bool": {
            "must": [
                {
                    "query_string": {
                        "query": "*Maisha*",
                        "fields": [
                            "name"
                        ]
                    }
                },
                {
                    "match": {
                        "school_type": "public"
                    }
                }
            ]
        }
    }

结果：

{
   name: 'Maisha school of sience',
   school_type: 'public',
   location: 'A',
}

这个结果实际上是有道理的，因为它给出了准确的结果，但没有显示宿舍和大学数据，这是主要问题。换句话说，我只希望school_type是public，但为什么它会过滤掉并且不显示大学和宿舍数据？

Answer 1

您几乎是正确的，只需将 bool 中的 must 更改为 should 即可。我刚刚索引了您的示例数据并使用下面的查询。

示例文档

{
        "name": "Maisha school of sience",  // doc-1
        "school_type": "public",
        "location": "A"
}
{
        "name": "istanbul university", // doc-2
        "university_type": "public",
        "location": "C"
}
{
        "name": "Maisha university", // so on
        "university_type": "private",
        "location": "D"
}
{
        "name": "kbb center of Maisha",
        "dormitory_type": "public",
        "location": "E"
}
{
        "name": "high Maisha dorm",
        "dormitory_type": "private",
        "location": "F"
}

{
    "query": {
        "bool": {
            "should": [. ->> notice should clause here
                {
                    "query_string": {
                        "query": "*Maisha*",
                        "fields": [
                            "name"
                        ]
                    }
                },
                {
                    "match": {
                        "school_type": "public"
                    }
                }
            ]
        }
    }
}

它返回以下结果，希望您正在寻找相同的输出。

{
    "took": 12,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 4,
            "relation": "eq"
        },
        "max_score": 1.287682,
        "hits": [
            {
                "_index": "71296703",
                "_id": "1",
                "_score": 1.287682,
                "_source": {
                    "name": "Maisha school of sience",
                    "school_type": "public",
                    "location": "A"
                }
            },
            {
                "_index": "71296703",
                "_id": "3",
                "_score": 1.0,
                "_source": {
                    "name": "Maisha university",
                    "university_type": "private",
                    "location": "D"
                }
            },
            {
                "_index": "71296703",
                "_id": "4",
                "_score": 1.0,
                "_source": {
                    "name": "kbb center of Maisha",
                    "dormitory_type": "public",
                    "location": "E"
                }
            },
            {
                "_index": "71296703",
                "_id": "5",
                "_score": 1.0,
                "_source": {
                    "name": "high Maisha dorm",
                    "dormitory_type": "private",
                    "location": "F"
                }
            }
        ]
    }
}