#6433: GROUP BY support in Containable behaviour -----------------------------------+---------------------------------------- Reporter: eimermusic | Type: Enhancement Status: new | Priority: Medium Milestone: 1.3.x.x | Component: Components Version: 1.2 Final | Severity: Normal Keywords: containable, group | Php_version: n/a Cake_version: 1.2.3.8166 | -----------------------------------+---------------------------------------- The subject sort of sums it up.[[BR]] I'd love to see support for GROUP BY in Containable. I had a look around but the inner workings of Containable was a bit bewildering to me.[[BR]] [[BR]] For example this would be nice to have when you want some simple "statistical spread" of values in a realted model instead of the full data or just a count. {{{ 'contain' => array( 'Answer' => array( 'fields' => array('Answer.value','COUNT(*) as count'), 'group' => array('Answer.value') ) ) }}} I tried to just add group to the list of options in Containable (267) but that just got me from SQL error to ignored group statement. I tried to figure out where the group key gets dropped but gave up after a while.
-- Ticket URL: <https://trac.cakephp.org/ticket/6433> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---