Confusing regarding rails query

Question

So I have this query

Vote.group(:photo_id).order('count_all desc').limit(10).count

that fetches all the votes and groups them by their photo_id and totals up the votes for those ids. I would like to add another constraint to it to only grab the ones with a vote count greater than X. I know I have to add a .where function somewhere but I'm not entirely sure where to put it or how to add in the new constraint...

I'm not rails expert but that code seems kind of odd. I think order doesn't matter when you are just counting. Also I'm not sure, but the count might always be 10 because of the limit. Please correct me if I'm wrong. — semperfids
– semperfids, Commented Oct 9, 2015 at 22:01
Well the count will always be 10 unless there are less than 10 votes @semperfids. But you're right using count with limit is odd. — max
– max, Commented Oct 9, 2015 at 22:03
@max Right now it's pulling 10 records max and giving me an aggregate count of the votes by photo_id, sorted by most votes descending. I want to be able to say. Only pull these if the count of the aggregate votes for the photo are greater than X. If that makes sense? — user3298823
– user3298823, Commented Oct 9, 2015 at 23:31

Philip Hallstrom · Accepted Answer · 2015-10-10 17:35:11Z

1

You want having (SQL keyword as well as Rails method):

http://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-having

Vote.group(:photo_id).having('COUNT(*) > ?', x)…

answered Oct 10, 2015 at 17:35

Philip Hallstrom

19.9k2 gold badges44 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Confusing regarding rails query

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