CODEWITHSUNDEEP
ruby-on-railsrubyactiverecordruby-on-rails-4
zakelfassi
zakelfassi

Reputation: 2966

Scope on number of items in associated model

Suppose we have a Tag model with many associated Post (or none) via a has_many association.

Is there an efficient way to select only the tags that do have a tag.posts.size > 0 via a scope ?

Something that would behave as follows:

scope :do_have_posts, -> { where("self.posts.count > 0") } #pseudo-code

Thanks.

Upvotes: 0

Views: 52

Answers (1)

usha
usha

Reputation: 29349

This should only return you the tags with posts since rails does an inner join by default

scope :with_posts, -> { joins(:posts).uniq }

Upvotes: 2

Related Questions