Rails query WHERE clause using OR

Question

i have 2 individual RAILS queries that both work fine on their own:

@charts = Chart.where(:patient_id => @emailpatient.id)

@charts = Chart.where(:patient_id => @sharepatient.id)

that i want to simply combine into a single 'OR' query. i tried:

@charts = Chart.where(:patient_id => @sharepatient.id OR :patient_id => @emailpatient.id)

and

@charts = Chart.where("patient_id => @sharepatient.id OR patient_id => @emailpatient.id")

and various other variations and cant get it to work. Where am i going astray?

You should get the queries in console where you ran ”rails server”. What does it say there? — Smar
– Smar, Commented May 21, 2013 at 7:37
Or rather, this is either syntax error (is uppercase OR available as comparison operator?) — Smar
– Smar, Commented May 21, 2013 at 7:38
@Smar the first line, he does not write the condition in a string => out. Then he does but does not interpolate both values. — Benoît
– Benoît, Commented May 21, 2013 at 7:41
@charts = Chart.where(:conditions => ["patient_id => ? OR patient_id => ?", @sharepatient.id, @emailpatient.id]) — Yevgeniy Anfilofyev
– Yevgeniy Anfilofyev, Commented May 21, 2013 at 7:45

Benoît · Accepted Answer · 2013-05-21 07:38:05Z

8

You can do

@charts = Chart.where(:patient_id => [@emailpatient.id, @sharepatient.id])

answered May 21, 2013 at 7:38

Benoît

14.5k7 gold badges65 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

This translates to a WHERE patient_id IN (...) clause, which is logically equivalent but has the advantage of working for N ids.

Nerve · Accepted Answer · 2013-05-21 07:54:24Z

5

You got it slightly wrong.

@charts = Chart.where("patient_id = ?  OR patient_id = ?", @sharepatient.id, @emailpatient.id)

answered May 21, 2013 at 7:54

Nerve

6,9314 gold badges32 silver badges29 bronze badges