Por que recebo erro nessa coluna?
Eu tenho modelo de empresa e modelo Invintaton, as empresas podem convidar outras empresas para mensagens e agora eu preciso mostrar apenas as empresas que confirmam as mensagens
class Company < ActiveRecord::Base
has_many :sent_invitations, class_name: 'Invintation', foreign_key: 'sender_id'
has_many :invitation_recipients, through: :sent_invitations, source: :recipient
has_many :incoming_invitations, class_name: 'Invintation', foreign_key: 'recipient_id'
has_many :invitation_senders, through: :incoming_invitations, source: :sender
end
class Invintation < ActiveRecord::Base
belongs_to :recipient, class_name: 'Company', foreign_key: 'recipient_id'
belongs_to :sender, class_name: 'Company', foreign_key: 'sender_id'
end
class MessagesController < ApplicationController
def new
@company = Company.find(params[:company_id])
@message = @company.sent_messages.new
@recipients = Company.joins(:invitation_recipients).where(invitation_recipients: {sender_id: @company.id, confrm: true})
end
end
mas recebo o erro SQLite3 :: SQLException: não existe essa coluna: sent_invitations.confrm: SELECT "companies". * FROM "companies" INNER JOIN "invintations" ON "invintations". "sender_id" = "companies". "id" WHERE " sent_invitations "." confrm "= 't'
E eu sei que dessa forma mostro apenas as empresas que estavam enviando o convite, e é necessário, e incluiu um convite