exporting When exporting orders, it only exports the orders on page 1 instead of all within the search parameters

[FrederikF]

I'm having trouble with the export function on the backend order page.

I'd like to export all orders within a certain time period. 
But for some reason prestashop only allows me to export what is on page 1, while I want all 20 pages of orders that's within my search parameter.

If anyone knows what code to modify I'd appreciate your expertise.  

I'm using Prestashop 1.7.6.9

[Constantino]

if you don't mind using third-party tools for this, you can export order for the predefined period of time using trial version of Store Manager

[mgo3]

I have the same problem. I modified this->getList($this->context->language->id); to this->getList($this->context->language->id, null, null, 0, false); at AdminController.php but it didn't work. Any clue? 

Thank you! 

[knacky]

Only what is visible is exported.
Because the sql query already contains a paging condition.
So sql contains, for example, the where filter and LIMIT 10, 20.

You can click on the "create sql query" button and see how Prestashop creates sql.