named_scope

rubyonrails-talk
1

Hi,

I'm trying to make a named_scope that only lists Products with at least 1 comment. product.comments.size > 0

*Product

has_many :comments

*Comment

belongs_to :product

I haven't figured out how to using count/size for my conditions.

Regards

2

product.comments.length is what you're looking for.

Also check out my 2 favorite versions of the ruby and rails API's here:

Ruby: http://www.rubybrain.com/api/ruby-1.8.6/doc/index.html

Rails: http://www.railsbrain.com/api/rails-2.0.2/doc/

3

I think it would be enough to force an inner join:

   named_scope :commented, :joins => :comments    # => SELECT * FROM "products" INNER JOIN "comments" ON comments.product_id = products.id