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.073 seconds

“

”

Love COOKING with COOK It has all the ingredients for a delicious Joomla component!
audibleid (Forum)