TOPIC:

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

ewajoom
Topic Author
Offline
Junior Member
Posts: 36
Thank you received: 2

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.

group by in grid layouts 05 Nov 2013 18:23 #11539

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.

group by in grid layouts 05 Nov 2013 21:27 #11540

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.

Page:
1

Forum

Support forum

Trouble shooting

group by in grid layouts

Time to create page: 0.072 seconds

“

”

I must say that I'm leaps and bounds ahead of where I would have other been with J2.5 with full thanks to the folks on this forum and specifically to Cook so you'll never hear me complaining.
gdpodesta (Forum)

TOPIC:

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

group by in grid layouts 05 Nov 2013 18:23 #11539

group by in grid layouts 05 Nov 2013 21:27 #11540

Get Started

Newsletter