About new pagination feature

[canob]

Hi everyone,

I managed to connect OpenObserve to Grafana with Infinity Plugin, with JSON Backend POST, using this URL, http://openobserve:5080/api/default/_search?type=logs, and with this Raw body type with JSON Content Type:
{"query":{"sql":"select * from "windows"","start_time":${__from}000,"end_time":${__to}000,"from":0,"size":10000}}

I want to "manage" that "size" field with new pagination feature. Is it possible?

Thanks in advance for your help.

[canob]

Nobody?

[lakshay2711]

Hello @canob ,

did you got any solution?
Also I have a kind of similar question regarding the size have you ever tried to provide a size greater than 10000 if your ES has more than 10K records? Does it work?
For me it gives a 400 bad request error in grafana. Does Grafana has a limitation or are you aware of any workaround for this issue ?

[canob]

Hi @lakshay2711.
No, I gave up, and I didn't get any response.
I'm using OpenObserve, but in the case of ElasticSearch, I think that is more complicated, because you need to use an additional parameter, search_after, https://www.elastic.co/guide/en/elasticsearch/reference/current/paginate-search-results.html, and I don't know how you can manage that kind of things with this new pagination feature of Infinity Datasource Plugin.