PS. Here's example of the SQL code used to give some more details (have
used different model names). Again the question is whether there is a way
with ActiveRecord to construct the query "return all the BankAccount's for
which they have more than 100 AccountItem's". (i.e. using "through", named
scopes or whatever)
SELECT ba.* FROM bank_accounts AS ba
LEFT JOIN account_items AS ai
ON ai.bank_account_id = ba.id
GROUP BY ba.id
HAVING COUNT(ai.id) > 100
Thanks
On Mon, Jan 19, 2009 at 5:21 PM, Greg Hauptmann <
[email protected]> wrote:
> Hi,
>
> Can I get an ActiveRecord.find to do this query?: *Get all Articles
> which have only been published in less than X Magazines.*
>
> Model Relationship: "Magazine" has_and_belongs_to_many "Articles"s.
>
> thanks
>
>
>
>
>
>
> --
> Greg
> http://blog.gregnet.org/
>
>
>
--
Greg
http://blog.gregnet.org/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
