elasticsearch - 使用开始和结束日期查询以获取可用日期

Question

我正在尝试创建一个查询，该查询返回的商品在该日期(或日期范围)没有保留，或者根本没有保留。这让我疯狂。

这是我当前使用索引设置的映射:

{
  "development_product_instances" : {
    "aliases" : { },
    "mappings" : {
      "product_instance" : {
        "properties" : {
          "reservations" : {
            "type" : "nested",
            "properties" : {
              "end_date" : {
                "type" : "date",
                "format" : "yyyy-MM-dd"
              },
              "start_date" : {
                "type" : "date",
                "format" : "yyyy-MM-dd"
              }
            }
          }
        }
      }
    },
    "settings" : {
      "index" : {
        "creation_date" : "1503327829680",
        "number_of_shards" : "5",
        "number_of_replicas" : "1",
        "uuid" : "9b9BhF-ITta2dlCKRLrnfA",
        "version" : {
          "created" : "2040499"
        }
      }
    },
    "warmers" : { }
  }
}

和查询:

  {
    bool: {
      should: [
        {
          nested: {
            path: "reservations",
            filter: {
              bool: {
                must_not: [
                  {
                    range:
                      {
                        "reservations.start_date":
                         {
                           gte: start_date,
                           lte: end_date
                         }
                      }
                  },
                  {
                    range:
                      {
                        "reservations.end_date":
                         {
                           gte: start_date,
                           lt: end_date
                         }
                      }
                  }
                ]
              }
            }
          }
        },
        {
          not: {
            nested: {
              path: "reservations",
              filter: {
                match_all: {}
              }
            }
          }
        }
      ]
    }
  }

如果预订超过一个，它将返回全部。

我希望有人可以在那里看到错误。也许我在全局中缺少某些东西。

Answer 1

您的问题是must_not在nested查询中。这意味着，如果它为匹配任何嵌套保留的，则父文档匹配。因此，当有多个预留时，除非您要查询的范围与现有预留的全部重叠，否则您将获得匹配。您可以像这样重写它(请注意，当预订为空时，此查询也会匹配):

{
  "query": {
    "bool": {
      "must_not": {
        "nested": {
          "path": "reservations",
          "query": {
            "bool": {
              "should": [
                {
                  "range": {
                    "reservations.start_date": {
                      "gte": start_date,
                      "lt": end_date
                    }
                  }
                },
                {
                  "range": {
                    "reservations.end_date": {
                      "gte": start_date,
                      "lt": end_date
                    }
                  }
                }, 
                {
                  "bool": {
                    "must": [
                      {
                        "range": {
                           "reservations.start_date": {
                             "lt": start_date
                           }
                        }
                      },
                      {
                        "range": {
                           "reservations.end_date": {
                             "gt": end_date
                           }
                        }
                      }
                    ]
                  } 
                }
              ]
            }
          }
        }
      }
    }
  }
}