AGgregation query not working related to child document

Elastic Stack Elasticsearch
1 
 "aggregations": {
    "terms_parent_id": {
      "terms": {
        "field": "user_id",
        "size": 10000,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          {
            "_count": "desc"
          },
          {
            "_key": "asc"
          }
        ]
      },
      "aggregations": {
        "TRANS_CHILDREN_TYPE": {
          "children": {
            "type": "ecom_page_view_id"
          },
          "aggregations": {
            "TRANS_TIME_FILTER_RANGE": {
              "filter": {
                "range": {
                  "ecom_created": {
                    "from": "2022-07-04 09:18:02",
                    "to": "2022-07-04 14:18:02",
                    "include_lower": true,
                    "include_upper": true,
                    "boost": 1
                  }
                }
              },
              "aggregations": {
                "PRODUCT": {
                  "nested": {
                    "path": "items"
                  },
                  "aggregations": {
                    "PRODUCT_FILTER": {
                      "filter": {
                        "bool": {
                          "should": [
                            {
                              "bool": {
                                "adjust_pure_negative": true,
                                "boost": 1
                              }
                            }
                          ],
                          "adjust_pure_negative": true,
                          "boost": 1
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        },
        "bucket_selector_page_id_term_count": {
          "bucket_selector": {
            "buckets_path": {
              "children_count": "TRANS_CHILDREN_TYPE>TRANS_TIME_FILTER_RANGE>PRODUCT>PRODUCT_FILTER._count"
            },
            "script": {
              "source": "params.children_count  > 2",
              "lang": "painless"
            },
            "gap_policy": "skip"
          }
        }
      }
    }
  }

i have 2 child document .
 "source": "params.children_count  > 2",  i am getting the responce
2

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