Active Record join query

Question

I have three models: Question, User and Qrecord. A Qrecord stores how many times the User has answered the Question correctly (in the column :answered) and when it was last answered (in the column :last_answered).

So, a Question has_many Qrecords and a User has_many Qrecords. A Qrecord belongs_to :user and :question.

Qrecord Model

id :integer not null, primary key user_id :integer question_id :integer answered :integer last_answered :datetime

For an array of questions, how do I return the one in which :last_answered was the longest time ago?

wintermeyer · Accepted Answer · 2014-04-01 16:52:08Z

1

Assuming that the array of questions is questions and the user record user:

user.qrecords.where(question_id: questions.pluck(:id)).order(:last_answered).last.question

edited Apr 1, 2014 at 16:52

answered Apr 1, 2014 at 14:00

wintermeyer

8,3468 gold badges45 silver badges94 bronze badges

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

3 Comments

Finnjon Over a year ago

Nearly right. It also needs the user_id for the qrecord. If you edit it to make the where condition where(question_id: questions.pluck(:id), user_id: user)..., I will mark it as correct.

wintermeyer Over a year ago

In that case you can use user.qrecords.where.... I updated the answer.

wintermeyer Over a year ago

BTW: Accepting the answer would be very kind.

Collectives™ on Stack Overflow

Active Record join query

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related