How to query on two fields in rails?

Question

Ruby on Rails

How to correctly write a query to select from a table by two fields, if the id matches in the sender_id column or in the recipient_id column, then take them together?
@recipients = Company.joins(:invitations).where(invitations: {sender_id: @company.id OR recipient_id: @company.id ,confirm: true})

Answer 1

Company.joins(:invitations).where('invitations.sender_id = ? OR invitations.recipient_id = ? ', @company.id, @company.id)