Try Minisection.find(minisection_id).questions.pluck(:id)
On Fri, Feb 28, 2014 at 12:33 AM, Dave Castellano <[email protected]>wrote: > Hi, > > I am trying to do the following database query (ie find all question > id's with the selected minisection id): > > minisection_questions = Question.where(minisection_id: > minisection_id).pluck(:id) > > I have a question table, a minisection table, and a > minisections_questions join table. > > Question model - has_and_belongs_to_many :minisections > Minisection model - has_and_belongs_to_many :questions > > I get the following error: > PGError: ERROR: column questions.minisection_id does not exist > LINE 1: SELECT id FROM "questions" WHERE "questions"."minisection_i... > ^ > : SELECT id FROM "questions" WHERE "questions"."minisection_id" = 2 > > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/3202d2b108b746f5280797b3d3c43a2e%40ruby-forum.com > . > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CALFmRoGB0q9YBsfm1ffz4cYBpSCzxe5SMSFhDhJLs3RMG%3DH9Tg%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
