When creating a custom find for a model, with AR it is possible to do
:conditions => [‘user_id = ?’, params[:id]]
However, I would like to know if it is possible to do the same when
specifying a JOIN:
:joins => [‘LEFT OUTER JOIN orders ON (items.order_id = orders.id AND
orders.user_id = ?’, params[:id]]
I tried the above expression, but unfortunately, Rails didn’t replace
the question mark with its escaped value.
Any idea if this is possible? I need to move some filtering from the
WHERE clause into the ON clause and have it all escaped.