dazmania Posted January 28, 2015 Posted January 28, 2015 (edited) 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) Share this post Link to post Share on other sites More sharing options...
shinichi81 Posted February 5, 2015 Posted February 5, 2015 i need solve too, i had met trouble with groupby in admin order.. Share this post Link to post Share on other sites More sharing options...
tuk66 Posted February 5, 2015 Posted February 5, 2015 Try $this->_group = 'GROUP BY a.`id_order`'; 2 Share this post Link to post Share on other sites More sharing options...
shinichi81 Posted February 11, 2015 Posted February 11, 2015 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 Share this post Link to post Share on other sites More sharing options...
tuk66 Posted February 12, 2015 Posted February 12, 2015 For that is WHERE part of query $this->_where = ' AND a.`id_order` = 1; 1 Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now