You may need to use the join option directly, instead of Containable.
http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#joining-tables
On Thursday, 8 May 2014 00:15:29 UTC+10, Harold Putman wrote:
>
> I am trying to get a SUM of a column of related records through the
> Containable behavior.
> I've tried a number of variations based on information google turned up
> but I cannot get it to work:
>
> $accounts = $this->find('all', array(
> 'contain' => array('Registration' => array('fields' =>
> array('SUM(`credits`)'),
> 'group' => array('Registration.account_id')))
> ));
>
> I soon as I add the "group" part, I get: Model "Registration" is not
> associated with model "Registration"
>
> Here's what I am trying to do in SQL:
>
> SELECT
> accounts.*,
> SUM(registrations.credits) AS slot_count
> FROM accounts
> LEFT JOIN registrations
> ON (*accounts.id <http://accounts.id>*=registrations.account_id)
> AND registrations.attend=1
> GROUP BY accounts.id
>
> Maybe I need to just use that query directly instead of trying to use
> Containable?
>
> Thanks for any advice..
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
