Order by 2 different fields in a renderlist

[piribipipi]

HI... its possible to order a query by 2 different fields in a renderlist??

for example, i have module with 2 important fields called Priority and Status. I would like to order by priority DESC and status ASC... but i dont find a way to do that.... 

is that possible?????

 

thanks

[NemoPS]

It seems like you can


http://www.mysqltutorial.org/mysql-order-by/

[piribipipi]

hi @NemoPs

Yes, i know how to order by two fields on mysql... but... how can i do that with a helperlist in Prestashop??

when u create an admin controller, u can specify this parameters for example:

$this->_orderBy = 'priority';

$this->_orderWay = 'DESC';

 

But... there is a way to do something like this:

 

$this->_orderBy = 'priority, status';

$this->_orderWay = 'DESC, ASC';

 

I hope u understand my idea

 

Thank u so much

[NemoPS]

Unless that one you posted works, then no, you can't with the helper. I haven't tried with it to be honest, but it will probably not work

[piribipipi]

no, it didnt work  hahaha

Well, i will continue searching a solution! thank you!