Query thru association

rubyonrails-talk
#1

Hi,

I'm stuck trying to figure out how to do a query to find all the
questions in a selected subject only.

My associations:

class Subject < ActiveRecord::Base
  has_many :books
  has_many :questions
  has_many :chapters, :through => :books
  has_many :sections, :through => :chapters
  has_many :subsections, :through => :sections
  has_many :minisections, :through => :subsections

class Question < ActiveRecord::Base
  has_and_belongs_to_many :minisections

The query:
@question_list = Question.where(all the questions associated with the
subject through the above associations???)

Any suggestions where to start would be appreciated.

Thanks,
Dave

#2

@question_list = @subject.questions

Note, though, that since you have subject has_many questions you also
need question belongs_to subject. Also you need to re-think your
associations as you have two routes to question from subject -
directly through the has_many but also right through the chain of
chapters, etc.

Colin

#3

Colin Law wrote in post #1161913: