弹性搜索--布尔查询中带有过滤器的问题

Question

我在布尔查询中有一个筛选器问题。

我想应用一个基于3个字段的筛选器，其中至少有1个筛选器匹配：

$params = [
    'from' => 0,
    'size' => 25,
    'index' => 'document',
    'body' => [
        'query' => [
            'bool' => [
                'filter' => [
                    'bool' => [
                        'minimum_should_match' => 1,
                        'should' => [
                            'term' => [
                                'VISIBILITE' => 'T'
                            ],
                            'term' => [
                                'ECRITURE' => 'M'
                            ],
                            'term' => [
                                'LECTURE' => 'M'
                            ],
                        ]
                    ]
                ],
                'must' => [
                    [
                        'bool' => [
                            'should' => [ 
                                [
                                    'match' => [
                                        'OBJET' => $recherche,
                                    ]
                                ],
                            ] 
                        ]
                    ],
                ],
            ],
        ],
    ],
];

我在这个查询中没有得到任何结果，但是我在索引中看到了很多相关的文档。

Opster Elasticsearch忍者测试：

例如你向我提出的1个例子，我有许多返回的结果。

然而，当我想对对象字段执行必须查询时，我没有得到与筛选器完美匹配的相同结果。

这里有一个例子：

1. 仅使用must子句进行搜索

{
    "took": 8,
    "timed_out": false,
    "_shards": {
        "total": 2,
        "successful": 2,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 1268,
            "relation": "eq"
        },
        "max_score": 13.616098,
        "hits": [
            {
                "_index": "document",
                "_type": "_doc",
                "_id": "26685",
                "_score": 13.616098,
                "_source": {
                    "NUMDOCUMENT": "26685",
                    "TYPEDOCUMENT": "Proc\u00e9dure",
                    "OBJET": "Proc\u00e9dure d'importation des index dans Marco 2",
                    "MOTCLES": "",
                    "LECTURE": "S",
                    "VISIBILITE": "T", // Must match on second search
                    "ECRITURE": "M" // Must match on second search
                }
            }
        ]
    }
}

{
    "took": 9,
    "timed_out": false,
    "_shards": {
        "total": 2,
        "successful": 2,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10000,
            "relation": "gte"
        },
        "max_score": 0,
        "hits": [
            {
                "_index": "document",
                "_type": "_doc",
                "_id": "431",
                "_score": 0,
                "_source": {
                    "NUMDOCUMENT": "431",
                    "TYPEDOCUMENT": "Document",
                    "OBJET": "Diagnostic informatique SAFC",
                    "LECTURE": "M",
                    "VISIBILITE": "T",
                    "ECRITURE": "M"
                }
            }
        ]
    }
}

首先出现的不再是同一文档（尽管该文档与筛选器相对应）。这就好像搜索过滤器影响了分数和相关性的搜索必须。

Answer 1

问题似乎与bool查询有关，如果您在顶层查看查询，您有两个构造

>

筛选块，它具有3个should条件，其中至少有1个条件应该匹配，这将筛选即减少将在其上执行下一个must子句的文档集。

必须阻止，我怀疑没有匹配从步骤1的缩减文档集上的任何东西，这导致您的查询没有返回任何东西。

为了调试该问题，您应该单独尝试第一个块，然后在合并时再尝试，看看是否得到结果，因为您的must块没有正确的数据，我创建了以下示例，显示如果您有正确的数据，它将返回数据：

{
    "query": {
        "bool": {
            "should": [
                {
                    "term": {
                        "VISIBILITE": "T"
                    }
                },
                {
                    "term": {
                        "ECRITURE": "T"
                    }
                },
                {
                    "term": {
                        "LECTURE": "T"
                    }
                }
            ],
            "minimum_should_match": 1
        }
    }
}

和搜索查询结果，显示匹配单据的_source

"hits": [
            {
                "_index": "minshouldmatch",
                "_type": "_doc",
                "_id": "2",
                "_score": 1.5686158,
                "_source": {
                    "VISIBILITE": "T", 
                    "ECRITURE": "T",
                    "LECTURE": "T"
                }
            },
            {
                "_index": "minshouldmatch",
                "_type": "_doc",
                "_id": "1",
                "_score": 0.18232156,
                "_source": {
                    "VISIBILITE": "T", // note even only 1 condition matches still it comes in SR
                    "ECRITURE": "M",
                    "LECTURE": "M"
                }
            }
        ]