Max number of results in a query

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ElmarKnipp_

Whenever I do a query with NXQL I got the expected total size of the result set. If I try to retrieve the results, only the first 1000 are accessible. This behaviour is independent from the client I use (e.g. Python, Java).

I have done some research and it seems that this restriction comes from Elasticsearch.

My question: Is there a simple way to increase this limit? E.g. a configuration parameter in nuxeo.conf? Or at least a simple workaround to this restriction?

Konrad_Krenzlin

I think the issue is that Nuxeo pages the results if you want to or not and the max page size is 1000. You'll have to explicitly fetch subsequent pages to get more results. Basically, you retrieve the first results starting with currentPageIndex=0 and then increase currentPageIndex and retrieve again. Until you have all the results. That is when Nuxeo returns zero entries. That's what I am doing in Python.

def query_paged(self, query):
    index = 0
    while True:
        query_result = self.nx.documents.query({"query": query, "pageSize": 100, "currentPageIndex": index})
        page = query_result["entries"]
        if len(page) > 0:
            for entry in page:
                yield entry
        else:
            break
        index += 1

Nuxeo actually returns the number of results and pages (at least I think it does). So you could do it in a more sophisticated way.