Need to access DATA_HISTOGRAM buckets response keys in child aggregation

I want to apply some filters on the bucket response generated by the date_histogram , that filter is dependent on the key of the date_histogram output buckets.

Suppose I have following data in

{
   "entryTime":"",
   "soldTime:""
}

the elastic query is something like this

    {
      "aggs": {
        "date": {
          "date_histogram": {
            "field": "entryTime",
            "interval": "month",
            "keyed": true
          },
          "aggs": {
            "filter_try": {
              "filter": {
                "bool": {
                  "must": [
                    {
                      "range": {
                        "entryTime": {
                          "lte": 1588840533000
                        }
                      }
                    },
                    {
                      "bool": {
                        "should": [
                          {
                            "bool": {
                              "must": [
                                {
                                  "exists": {
                                    "field": "soldTime"
                                  }
                                },
                                {
                                  "range": {
                                    "soldTime": {
                                      "gt": 1588840533000
                                    }
                                  }
                                }
                              ]
                            }
                          },
                          {
                            "bool": {
                              "must_not": [
                                {
                                  "exists": {
                                    "field": "soldTime"
                                  }
                                }
                              ]
                            }
                          }
                        ]
                      }
                    }
                  ]
                }
              }
            }
          }
        }
      }
    }

So here in that bool query, I want to use the date generated for the specific bucket by date_histogram aggregation in both the range clauses instead of the hardcoded epoch time.

Even if we can access using script then also it's fine.

for further clarification, this is the boolean query and in the query want to replace this "DATE" with the date_histogram bucket key.

# (entryTime < DATE) 
# AND 
# (
#    (soldTime != null AND soldTime > DATE) 
#          OR 
#      (soldTime == NULL)
#  )

Thank you

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.