ES only returns 1000 records
Currently, ES only returns the first 1,000 records both for search results and search results downloadable file.
If a search query has more than 1,000 records, ES lets the user navigate between the pages until it is within the first 1,000 records. When it goes beyond 1,000th record ES raises error For example, do a generic query that returns more than 1000 records. Try navigating to the page to the last page, it will raise an error.