I like to use a dash of Arel for this (took a guess at the friendables
association class name, adjust as necessary):
current_user.profile.friendables.where(Friendable.arel_table[:from_id].eq(
current_user.id).or(Friendable.arel_table[:to_id].eq(current_user.id))).
where(accepted: true)
A bonus is that this will qualify the from_id/to_id columns with the
Friendable table name to avoid SQL errors if the column names clash with
any other tables included in the query.
I'd also consider adding an accepted scope to friendables:
scope :accepted, -> { where accepted: true }
Then, you could do this:
current_user.profile.friendables.accepted.where(Friendable.arel_table[:
from_id].eq(current_user.id).or(Friendable.arel_table[:to_id].eq(
current_user.id)))
Jim
On Friday, April 8, 2016 at 4:45:42 AM UTC-4, Giedrius Rimkus wrote:
>
> You can achieve this with:
>
> <%
> @friended = current_user.profile.friendables.where("from_id = :user_id OR
> to_id = :user_id", user_id: current_user.id).where(accepted: true)
> %>
>
> On Thursday, April 7, 2016 at 6:15:53 PM UTC+3, fugee ohu wrote:
>>
>> I need to select where column = (this||that) and someothercolumn=something
>>
>> <% @friended = current_user.profile.friendables.where("(from_id = ? OR
>> to_id = ?) AND accepted = true)", current_user.id, current_user.id) %>
>>
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/205c2eec-bb12-4472-928b-c2b66028334e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
