# How to get data in chunks | need for pagination

**URL:** <https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [January 17, 2019, 9:00am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594 "2019-01-17T09:00:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ashish.Singh](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@Ashish.Singh](https://discuss.elastic.co/u/Ashish.Singh)\
**Post date:** [January 17, 2019, 9:00am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594/1 "2019-01-17T09:00:54Z")

</div>

I am trying to implement pagination in my React Grid . In the base I am using SQL query to get data from ElasticSearch.

I need something like ,

SELECT\* FROM bank ORDER BY account\_number OFFSET 5 \* (1 - 1) ROWS FETCH NEXT 50 ROWS ONLY

Which gives me next 50 or 100 records per hit/page. How can I achieve that. Please help me.

---

<div class="post-metadata">

**Author:** ![DavidTurner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/davidturner/32/22453_2.png) [@DavidTurner](https://discuss.elastic.co/u/DavidTurner)\
**Post date:** [January 17, 2019, 9:14am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594/2 "2019-01-17T09:14:51Z")

</div>

This sounds like a job for the [scroll API](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html).

---

<div class="post-metadata">

**Author:** ![Ashish.Singh](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@Ashish.Singh](https://discuss.elastic.co/u/Ashish.Singh)\
**Post date:** [January 17, 2019, 9:37am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594/3 "2019-01-17T09:37:49Z")

</div>

but, do sql-cli provide such mechanism or I need to go for JSON query style as shown in scroll Api shared link.  
I want to achieve the same as "scroll api" through sql query style if possible.

---

<div class="post-metadata">

**Author:** ![DavidTurner](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/davidturner/32/22453_2.png) [@DavidTurner](https://discuss.elastic.co/u/DavidTurner)\
**Post date:** [January 17, 2019, 10:54am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594/4 "2019-01-17T10:54:09Z")

</div>

Sorry, I missed that you want to access this feature with SQL. I do not know that this is possible through the SQL API right now.

---

<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:** [February 14, 2019, 10:54am UTC](https://discuss.elastic.co/t/how-to-get-data-in-chunks-need-for-pagination/164594/5 "2019-02-14T10:54:13Z")

</div>

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