# Query to get all records until the sum of column less than or equal a value

**URL:** <https://discuss.elastic.co/t/query-to-get-all-records-until-the-sum-of-column-less-than-or-equal-a-value/197302>\
**Category:** Elasticsearch\
**Created:** [August 29, 2019, 9:33am UTC](https://discuss.elastic.co/t/query-to-get-all-records-until-the-sum-of-column-less-than-or-equal-a-value/197302 "2019-08-29T09:33:42Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [September 3, 2019, 3:41am UTC](https://discuss.elastic.co/t/query-to-get-all-records-until-the-sum-of-column-less-than-or-equal-a-value/197302/5 "2019-09-03T03:41:40Z")

</div>

Could you provide a full recreation script as described in [About the Elasticsearch category](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

So provide an example dataset we can play from.

---

_[View the full topic](https://discuss.elastic.co/t/query-to-get-all-records-until-the-sum-of-column-less-than-or-equal-a-value/197302)._