[SOLVED] How to change default sorting of "Customer messages" from ascending to descending?

[noesac]

Where can I find this SQL query?

[rocky]

Try changing line 72 of admin/tabs/AdminMessages.php from:

ORDER BY '.(isset($orderBy) ? pSQL($orderBy) : 'date_add') .' '.(isset($orderWay) ? pSQL($orderWay) : 'DESC').'

to:

ORDER BY '.(isset($orderBy) ? pSQL($orderBy) : 'date_add') .' '.(isset($orderWay) ? pSQL($orderWay) : 'ASC').'

[noesac]

Hi Rocky, I just tried this and don't think it works.

Which is weird because it seems like the obvious place for it. There's another DESC in the file but changing this to ASC didn't work either.

[Pippo3000]

Where can I find this SQL query?

would be interested in this, too, as it is annpying to scroll down to the bottom of a page to see latest messages, would be quite natural to see latest on top.

Phil

[noesac]

woo hoo! I figured it out.

You need to change line #42 (instead of #72):

from:

            $orderWay = Tools::getValue($this->table.'Orderway', 'ASC');        

to:

            $orderWay = Tools::getValue($this->table.'Orderway', 'DESC');