Re: Pagination with HasMany and SQL Aggregation

I needed to that a little while ago and got it to work with some
slightly ugly hacking that probably doesn't scale too well, but it
might work for you too. :)

This belongs in the controller:
http://bin.cakephp.org/view/1990384829

On 4 Nov 2008, at 13:20, mwcbrent wrote:

>
> I'm not sure that this is possible but if it is, it would put Cake
> into a special place in my heart. I have 2 related models Articles
> and Ratings.
>
> Articles hasMany Ratings
>
> A Rating has a User ID an Article ID and a Rating #. In order to get
> an articles rating I need to query all ratings by the Article ID and
> average them out.
>
> How would I paginate all Articles ordered by Rating?
> >

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---