Filter model association count by date?

Question

I have the following models: User, Call.

A User has_many Calls.

A Call has a column: created_at

I need to filter the users who have the most calls in the last 'x' days.

I'm here so far:

User.includes(:calls).limit(10).where("created_at > ?", Time.now - 20.days)

score 0 · Answer 1 · answered Nov 22 '13 at 08:59

0

User.includes(:calls).where("calls.created_at > ?", Time.now - 20.days).limit(10)

answered Nov 22 '13 at 08:59

Thaha kp

Thanks, but it doesn't do: "who have the most calls". – Alex D. Nov 22 '13 at 09:02
1

Please refer this answer http://stackoverflow.com/questions/8696005/rails-3-activerecord-order-by-count-on-association – Thaha kp Nov 22 '13 at 09:23

score 0 · Answer 2 · answered Nov 22 '13 at 11:01

0

You should go from Calls here, not from Users. Something like:

Call.where("created_at > ?", Time.now - 20.days).group(:user_id).order("count(user_id) DESC").count("user_id")

As a result you get a hash with key - user_id and value - number of calls

answered Nov 22 '13 at 11:01

Andrey Sereda

2 Answers2