# Paginate SQL queries (in Canvas)

**URL:** <https://discuss.elastic.co/t/paginate-sql-queries-in-canvas/203285>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql, canvas\
**Created:** [October 11, 2019, 7:13pm UTC](https://discuss.elastic.co/t/paginate-sql-queries-in-canvas/203285 "2019-10-11T19:13:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![daq](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/daq/32/33426_2.png) [@daq](https://discuss.elastic.co/u/daq)\
**Post date:** [October 11, 2019, 7:13pm UTC](https://discuss.elastic.co/t/paginate-sql-queries-in-canvas/203285/1 "2019-10-11T19:13:47Z")

</div>

I need to build a Canvas chart from a query that returns ~100K results.  
I'm building it using an enormously helpful suggestion I found on this forum for grouping counts into columns:

```
filters
| essql 
  query="SELECT COUNT(*) as hits, userid FROM \"tracking-*\" WHERE \"@timestamp\" > CURRENT_DATE - INTERVAL '1' DAY GROUP by userid"
| mapColumn "range" 
  fn={getCell "hits" | switch case={case if={all {eq 1}} then="1"} case={case if={all {eq 2}} then="2"} case={case if={all {eq 3}} then="3"} default="More"}
| sort by="range"
| pointseries x="range" y="size(hits)"
| plot defaultStyle={seriesStyle bars=.4} yaxis=true
| render

```

How do I get past the 1000 results limit?

Thanks!

---

<div class="post-metadata">

**Author:** ![matriv](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matriv/32/43656_2.png) [@matriv](https://discuss.elastic.co/u/matriv)\
**Post date:** [October 16, 2019, 4:33pm UTC](https://discuss.elastic.co/t/paginate-sql-queries-in-canvas/203285/2 "2019-10-16T16:33:53Z")

</div>

Have you checked the documentation here: [https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-pagination.html](https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-pagination.html) ?

---

<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:** [November 13, 2019, 4:34pm UTC](https://discuss.elastic.co/t/paginate-sql-queries-in-canvas/203285/3 "2019-11-13T16:34:06Z")

</div>

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