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.
This sounds like a job for the scroll API.
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.
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.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.