Limit number of orders in BO Orders Tab

[LukaM]

Hi, is there possible to force BO orders tab to show only orders (for example) from last 30 days? With more than 600k orders waiting for list take like forever. Using date limit is helpful of course, and we are working only at limited number of orders at time, but waiting for this first list (without time limit as it is by default) is really annoying.

Edited February 21, 2021 by LukaM (see edit history)

[LukaM]

After 36 hours only idea is to force datepicker to pick some default start date (ex. beginning of year). In theory changing  alendar.js datepickerStart value should be enough but I can force it to work. Any ideas?

[LukaM]

Maybe not perfect solution but works for me fine, and maybe someone will need it in future:

 

In AdminOrdersControler.php

After:

IF(a.valid, 1, 0) badge_success';

Add:

if ($this->context->employee->id_profile == X)
{
$this->_where .= ' AND a.id_order > Y';
}

Where:
X - Id of Employee Profile
Y - Id (-1) of order where we want to setup a limit.