How do I re-write "Feedback.where('poster_id = 3 OR receiver_id = 3')" in Rails 3.1?

Is there a way to write it in a more 'Rails-friendly' way?

i.e. if I were searching for anyone of those attribute开发者_如何学编程s, I would just do Feedback.where(:poster_id => 3) and it would be good.

But how do I achieve the OR in the Rails 3 friendly syntax (as opposed to the SQL friendly one).

Also, if it is better to use my original one over the desired one, why is it better?

Thanks.

Edit 1: Btw, if I do Feedback.where(:poster_id => 3, :receiver_id => 3) that returns the result for the AND operation, which is the exact opposite of what I want. So I feel so close, just not quite there.

---

You can do this by putting SQL fragments in the where() arguments. For more information you can look at the ActiveRecord querying guide.

Feedback.where("poster_id = ? OR receiver_id = ?", 1, 3)

You can do this without SQL fragments as described in this SO post:

t = Feedback.arel_table
Feedback.where(t[:poster_id].eq(1).or(t[:receiver_id].eq(2)))