ruby-on-rails - 基于has_one关系的rails查询

Question

class Hospital
 has_many: invoice_transaction, through: :invoices
 has_many: invoices
end 

class invoice
 belongs_to :hospital
end 

class InvoiceTransaction      
  belongs_to: invoice 
  has_one :hospital, through: :invoice
end 





hospital.invoice_transactions works well

现在我想InvoiceTransaction根据多个医院id查询

像这样的东西

InvoiceTransaction.joins(:hospital).find([.array of hospital ids..])

但这会返回空记录

标签： ruby-on-railsactiverecordassociations

Answer 1

使用where而不是find在您使用时使用joins

where('name_of_the_table.id in (?)', [医院 ID 数组])

InvoiceTransaction.joins(:hospital).where('hospitals.id in (?)', [array of hospital ids])