sql count filtering - rails way

Question

Suppose I have Posts and posts' Comments. I want to filter all the Posts that have more than 10 comments. I began writing something like Posts.includes(:comments).group("post.id").count("comments.id"), to obtain a hash of posts and their counts, and I can extract the information from there, but I want some one-line straightforward way to do that

Sure I can use some pure sql syntax statements, but I want it in a pure rails way. Any idea ?

Given that you accepted the answer, you might want to update your question to use the correct constants (e.g. Post, Comment), after which I'll update my answer to remove the reference to this. :-) — Peter Alfvin
– Peter Alfvin, Commented Dec 7, 2013 at 17:51

Peter Alfvin · Accepted Answer · 2013-12-07 16:01:43Z

2

Assuming the models are named in the more typical singular form of Post and Comment and have the usual association relationship, then the following should work:

Post.joins(:comments).group('posts.id').having('count(comments.id) > 10')

answered Dec 7, 2013 at 16:01

Peter Alfvin

29.6k9 gold badges72 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

sql count filtering - rails way

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related