topic Getting Pagination to work with ElasticSearch in QlikView

Getting Pagination to work with ElasticSearch

msuk121336387 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to ElasticSearch

I have connected to ElasticSeach and have been able to retrieve the first 10,000 records. I then started looking at the pagination settings to get it to bring back multiple sets of 10,000 records, but when I attempt this I get the total number of records back in the form of the first 10,000 over and over.

I am unsure as to which setting I should be using. I tried Offset, but was unable to find the offset and limit headers within the structure. I then looked the Next URL and Token options. Again nothing.

I am contemplating writing a custom script using a for loop, but I have seen some posts of people failing to get this working.

The question is, should I be using Offset, Next URL, Next Token options or is my only option to attempt a custom script?

This is the structure of what I get returned

root

Shard

hits_u0

hits

and then source being all the data fields.

Any help or examples would be grateful.

Re: Getting Pagination to work with ElasticSearch

Anonymous — Tue, 16 May 2017 14:25:41 GMT

Hi !

Did you resolve your issue?

I am trying to use custom pagination to retrieve data from elasticsearch but I am facing an issue. ..

if you have some useful information about it i'am really interested.

thanks in advance

Re: Getting Pagination to work with ElasticSearch

Anonymous — Mon, 16 Apr 2018 02:03:43 GMT

Trying to solve this problem of Custom Pagination with Elastic search. There isn't enough documentation from Qlik's side on this.

I am using Qlik Sense Feb 2018 release.

I tried using the scroll API but also didn't work. Got these weird

Select statement parser error at (,): Multi-line literals are not supported errors.

Currently I am pulling a day's record and concatenating in in a QVD. Is there a better way to do this? Can someone from Qlik please have a documentation around pulling data and Paginating from Elastic Search please.

Thant would be super helpful. Thank you!