在Elasticsearch中按嵌套字段值的总和查询文档

此处是ElasticSearch的初学者.

Rank beginner at ElasticSearch here.

我有一个客户列表，他们的订单是一个嵌套字段.假设文档结构如下:

I have a list of customers, and their orders as a nested field. Assuming a document structure like:

[
  { customerId: 123,
    birthday: 1980-01-01,
    orders: [
      {
        orderValue: 1500,
        orderDate: 2018-12-18T12:18:12Z
      },
      [...]
    ]
  },
  [...]
}

我要查询的是:从两个日期之间订购了一定数量的用户的列表.而且我希望能够将其与范围查询结合起来，例如生日.

What I'd like to query is: The list of users who ordered for a certain amount from between two dates. And I'd like to be able to combine that with a range query for, for example, birthday.

我已经到了可以通过聚合获取每个订户两个日期之间的和的顺序:

I've gotten to the point where I can get the sum ordered between two dates per subscriber using aggregations:

{
  "size": 0,
  "aggs": {
    "foo": {
      "nested": {
        "path": "orders"
      },
      "aggs": {
        "grouped_by_customerId": {
          "terms": {
            "field": "orders.customerId.keyword"
          },
          "aggs": {
            "filtered_by_date": {
              "filter": {
                "range": {
                  "orders.orderDate": {
                    "from": "2018-01-28",
                    "to": null,
                    "include_lower": false,
                    "include_upper": true,
                    "format": "yyyy-MM-dd",
                    "boost": 1
                  }
                }
              },
              "aggs": {
                "sum": {
                  "sum": {
                    "field": "orders.orderValue"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

但是，我想限制我在查询"部分返回的结果，以便与我们所有其他过滤器更好地混合.

However, I'd like to limit the results I get back in the Query part, to mix better with all our other filters.

我的第一个想法是拥有一个脚本过滤器，并将边界日期和最小值作为参数传递，但是随后我不得不遍历文档的嵌套文档，这似乎行不通.

My first thought was to have a script filter and pass the bounding dates and minimum value in as parameters, but then I'd have to iterate over a doc's nested documents, and that doesn't seem to work.

最后一个想法可能吗?如果可以，怎么办?

Is that last idea possible, and if so, how?

谢谢！