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

“

”

Excellent Tool ! This tool will save you a lot of time writing the same old structure. I've used others but this is really nice for a quick start. Makes a 3 hour task a 15 minute one. Thanks for this extension
dickrundell (JED)

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