thanks - I'll give it a try On Mon, Jan 19, 2009 at 8:53 PM, Frederick Cheung < [email protected]> wrote:
> > > On 19 Jan 2009, at 09:30, Greg Hauptmann wrote: > > > 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 > > > > > > BankAccounts.find :all, :select => 'bank_accounts.*', :joins => > 'account_items', :group => 'bank_accounts.id HAVING COUNT(ai.id) > 100' > > should do the trick. Edge has a :having option I think, but you can > fudge it into the group clause > > Fred > > > 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/ > > > > > > > > > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
