Change default sorting for the Orders Tab?

[TryTwo]

I've tried editing the AdminOrders.php file and the following line:

$this->getList((int)($cookie->id_lang), !Tools::getValue($this->table.'Orderby') ? 'date_add' : NULL, !Tools::getValue($this->table.'Orderway') ? 'DESC' : NULL);

 

But changing 'date_add' to 'order_state' doesn't work.

 

How do I change the default list of customer orders to be ASC by Status?

[TryTwo]

Figured it out

 

For those interested:

$this->getList((int)($cookie->id_lang), !Tools::getValue($this->table.'Orderby') ? 'osname' : NULL, !Tools::getValue($this->table.'Orderway') ? 'ASC' : NULL);

[Daniel - PrestaBR]

Hi there, everyone

 

Does anyone know how to show only orders from a certain amount in AdminOrders tab?

I need something like this:

SELECT * FROM  `ps_orders` WHERE  `total_paid` > 100;

Edited June 12, 2012 by DGV (see edit history)