One query for multiple boolean conditions limit 1 per condition

Asked Dec 11 '17 at 19:54

Active Dec 11 '17 at 20:00

Viewed 59 times

I'm trying to clean up some queries on an app I work on. Right now I'm performing 4 queries to the same table for very similar information

MyModel.order("for_date ASC").where('boolean_column_1 = ?', 'Y').last
MyModel.order("for_date ASC").where('boolean_column_2 = ?', 'Y').last
MyModel.order("for_date ASC").where('boolean_column_3 = ?', 'Y').last
MyModel.order("for_date ASC").where('boolean_column_4 = ?', 'Y').last

My question is: what's the best way to clean this up? I'd like to keep it to only 4 values returned, because it's a big table. I can't think of a good way to reduce this to one query

ruby version 2.1, rails version 3.2

edited Dec 11 '17 at 20:00

Brad Werth

17,411
10
63
88

asked Dec 11 '17 at 19:54

Andrew Algard

Are you really using Rails version 2? – Brad Werth Dec 11 '17 at 19:55
https://stackoverflow.com/questions/3684311/rails-how-to-chain-scope-queries-with-or-instead-of-and – Brad Werth Dec 11 '17 at 19:57
ruby version 2.1, rails 3.2 – Andrew Algard Dec 11 '17 at 19:58
The issue is it needs to limit one record returned for each boolean condition met. something along the lines of `MyModel.where("b1 = ? OR b2 = ?", Y, Y).limit_one_per_OR` – Andrew Algard Dec 11 '17 at 20:10

One query for multiple boolean conditions limit 1 per condition

0 Answers0