Ruby on Rails 2 query on association count

Question

This question is fairly similar to [1], except that I'm using Rails 2.3.5 (yes, old) and a complete newb at RoR. I have two models, Configfile and Signoff.

I want to find all Configfiles where the number of signoffs is < 2. Of course, I could do this by filtering the array manually, but this database is big and it's fairly slow.

class Configfile < ActiveRecord::Base
  belongs_to :computer
  has_many :signoffs,
           :dependent => :destroy
end

and

class Signoff < ActiveRecord::Base
  belongs_to :configfile
end

This seems like something that should be fairly easy to do in Rails, but I can't figure it out. My query looks like this so far, and I haven't gotten anything that works for limiting it by the number of signoffs.

configs = c.configfiles.find(:all,
                             :include => :signoffs,
                             :order => 'filename')

[1] Rails 3 query on condition of an association's count

klochner · Accepted Answer · 2011-06-25 00:39:28Z

2

Configfile.find(:all, :group=>"configfile_id", :joins=>:signoffs, :having=>"count(*) < 2")

Which should give you the same as the equivalent rails3:

Configfile.joins(:signoffs").group("configfiles.id").having("count_all < 2").count(:all)

edited Jun 25, 2011 at 0:39

answered Jun 24, 2011 at 21:54

klochner

8,1451 gold badge35 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Taj Morton Over a year ago

Thank you so much! The final solution I got working was: configfiles.find(:all, :group=>"configfile_id", :joins=>:signoffs, :having=>"COUNT(*) < 2") (changing count_all to COUNT(*) and .count to .find)

Collectives™ on Stack Overflow

Ruby on Rails 2 query on association count

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related