TOPIC:

group by in grid layouts 05 Nov 2013 10:17 #11538

Hi, when generated grid layout, the query only do an order (no group by).
To change this I have to manually edit in model :

//GROUP ORDER : Prioritary order for groups in lists
foreach($this->getState('query.groupOrder', array()) as $groupOrder)
$query->order($groupOrder);

//GROUP ORDER : Prioritary order for groups in lists
foreach($this->getState('query.groupOrder', array()) as $groupOrder)
$query->group($groupOrder);

Please Log in or Create an account to join the conversation.

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	This is absolutly normal. The grid groups are different than Group By from SQL. It only applies a prioritary order that is a group a FK value, the more oftenly) When the group value changes, it show a new header in the grid with contained elements inside. You can instance unlimited group levels. Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.

ewajoom Topic Author Offline Junior Member Posts: 36 Thank you received: 2	Okay I understand why it's like that, thanks for explanation. (the fact is that in this case I needed an SQL group by to use some aggregates functions in grid)
	Please Log in or Create an account to join the conversation.

Forum

Time to create page: 0.080 seconds

“

”

The j-cook project is one of the best of its kind and it is nice that we all try to contribute in little ways to make life easy for each other..

vlemos (Forum)