elasticsearch - Elasticsearch AND条件与词条查询

Question

这是我的搜索过滤器查询，
我想给条件加上“和”条件。
现在我已经给了必须在过滤条件内

'query' => [
    "filtered" => [
        "query" => [
            "match_all" => []
        ],
        "filter" => [
            "bool" => [
                "must" => [
                    "terms" => [
                        "num" => [
                            1,2,3
                        ]
                    ],
                    "terms" => [
                        "sample" => [
                            "a", "b"
                        ],
                    ]
                ]
            ]
        ],
        'query' => [
            'multi_match' => [
                'query' => "Hello",
                'fields' => ['text'],
                'operator' => 'and'
            ],
        ]
    ]
],

但它不起作用。还有其他解决方案吗？

Answer 1

您需要将terms过滤器再封装一个数组，否则bool/must会成为关联数组，而这并不是您想要的(即，其中一个terms过滤器被丢弃了)。

'query' => [
    "filtered" => [
        "query" => [
            "match_all" => []
        ],
        "filter" => [
            "bool" => [
                "must" => [
                   [                     <---
                      "terms" => [
                         "num" => [
                            1,2,3
                         ]
                      ]
                   ],                    <---
                   [                     <---
                      "terms" => [
                        "sample" => [
                            "a", "b"
                        ],
                      ]
                   ]                     <---
                ]
            ]
        ],
        'query' => [
            'multi_match' => [
                'query' => "Hello",
                'fields' => ['text'],
                'operator' => 'and'
            ],
        ]
    ]
],