# AGgregation query not working related to child document

**URL:** https://discuss.elastic.co/t/aggregation-query-not-working-related-to-child-document/308822
**Category:** Elasticsearch
**Tags:** painless
**Created:** [July 4, 2022, 2:38pm UTC](https://discuss.elastic.co/t/aggregation-query-not-working-related-to-child-document/308822 "2022-07-04T14:38:24Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Udayaprakash\_S\_10d](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/udayaprakash_s_10d/32/105116_2.png) [@Udayaprakash\_S\_10d](https://discuss.elastic.co/u/Udayaprakash_S_10d)
#### Post date: [July 4, 2022, 2:38pm UTC](https://discuss.elastic.co/t/aggregation-query-not-working-related-to-child-document/308822/1 "2022-07-04T14:38:24Z")

</div>

```auto
 "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

```

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 1, 2022, 2:38pm UTC](https://discuss.elastic.co/t/aggregation-query-not-working-related-to-child-document/308822/2 "2022-08-01T14:38:55Z")

</div>

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