SQL GROUP BY clause

[dazmania]

Hi,

 

I am basing my module around the AdminOrders controller, I am modifying the sql and am struggling with the simpliest of tasks - I need to place a 'group by' clause:

 

These are all fine

$this->_select = '...

$this->_join = '...

$this->_orderBy = 'id_order';
$this->_orderWay = 'DESC';

 

but this does not seem to work ?

 

$this->_groupBy = 'id_order';

Am I just being a dumbass ?

 

Cheers,

Darren

Edited January 28, 2015 by dazmania (see edit history)

[shinichi81]

i need solve too, i had met trouble with groupby in admin order..

[tuk66]

Try

$this->_group = 'GROUP BY a.`id_order`';

[shinichi81]

 

Try

$this->_group = 'GROUP BY a.`id_order`';

thanks sir, i'll try to use that's sintax but if i want use like --> id_order = 1, what should i do? i must use like this $this->_group = 'GROUP BY a.`id_order = 1`' or else? thanks

 

[tuk66]

For that is WHERE part of query

$this->_where = ' AND a.`id_order` = 1;