elasticsearch - 如何在 Elasticsearch 查询中组合 "must"和 "should"？

Question

我需要在 Elasticsearch 查询 DSL 中“翻译”这个伪 SQL 查询:

select from invoice where invoiceType = 'REGULAR' and receiver = 'CUSTOMER' and (invoiceStatus = 'DISPATCHED' or invoiceStatus = 'PAYED')

我有这个:

{
  "query": {
    "bool": {
      "must": [
        { "match": { "invoiceType":  "REGULAR" }},
        { "match": { "receiver": "CUSTOMER" }},
        { "bool" : {
            "should": [
                {"match" : {"invoiceStatus": "DISPATCHED"}},
                {"match" : {"invoiceStatus": "PAYED"}}
            ]
          }
        }
      ]
    }
  }
}

该查询返回 0 个结果，但我知道有很多结果与我要搜索的内容相匹配。 AFAIK, must就像'AND'和 should像“或”。我错过了什么？

Answer 1

不确定它是否适合您，但您可以尝试一下，看看会得到什么？虽然我做了一些改变 match至 term .希望这会帮助你。

GET /invoice/_search
{
   "query" : {
      "constant_score" : {
         "filter" : {
            "bool" : {
              "must" : [
                { "term" : {"invoiceType" : "REGULAR"}}, 
                { "term": { "receiver": "CUSTOMER" }},
                { "bool" : { 
                  "should" : [
                      {"terms": {"invoiceStatus": ["DISPATCHED","PAYED"]}}   
                  ]
                }}
              ]
           }
         }
      }
   }
}

或

GET /invoice/_search
{
   "query" : {
      "constant_score" : {
         "filter" : {
            "bool" : {
              "must" : [
                { "term" : {"invoiceType" : "REGULAR"}}, 
                { "term": { "receiver": "CUSTOMER" }},
                { "bool" : { 
                  "should" : [
                    {"term": {"invoiceStatus": "DISPATCHED"}},
                    {"term": {"invoiceStatus": "PAYED"}}     
                  ]
                }}
              ]
           }
         }
      }
   }
}