Combining multiple named scopes with OR

Question

I am trying to combine two scopes or add some more to an existing scope.

scope :public_bids, -> {
  where(status: [Status::ACCEPTED, Status::OUTBID, Status::SOLD, Status::NO_SALE],
        bid_type: [BidType::MANUAL, BidType::AUTO, BidType::LIVE])
scope :outbid_maxbids, -> {
  where(status: Status::OUTBID, bid_type: BidType::MAXBID)

I am having trouble determining how to OR them together or combine then into one scope. Any suggestions/guidance? I would prefer that they be combined into one single scope.

Soloma

See my answer to the same question here. Also note similar questions here and here – Tonsorial

Answer 1

I haven't tried using or in a scope, but you may be able to chain the scopes together using Rails 5's new or method, like this:

scope :public_or_outbid, -> {
  where(status: [Status::ACCEPTED, Status::OUTBID, Status::SOLD, Status::NO_SALE], bid_type: [BidType::MANUAL, BidType::AUTO, BidType::LIVE])\
  .or(where(status: Status::OUTBID, bid_type: BidType::MAXBID))
}

(Note that this only works in Rails 5)

You certainly can chain the conditions together like this:

MyObj.public_bids.or(MyObj.outbid_maxbids)

See this answer for more detail: Rails 5: ActiveRecord OR query

Sidra

Unfortunately we haven't upgraded to 5 yet :( – Soloma

Well what's the holdup? It's almost out of beta! ;) – Sidra

Answer 2

Rails 4 and older do not support OR query "natively". Looks like it will be introduced in Rails 5.

For now, you would have to use SQL with .where method:

YourModel.where('field1 = ? OR field2 = ?', 1, 2)

But, in your case, you are selecting using IN and = queries and the first field is in both scopes. So, it would not make much sense. Anyway, if you really have to, you might get away with this:

data = YourModel.public_bids.outbid_maxbids
YourModel.where(data.where_values.inject(:or))

Oleson