#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
-~----------~----~----~----~------~----~------~--~---

  • [CakePHP : The Rapid Dev... CakePHP : The Rapid Development Framework for PHP

Reply via email to