can we OR the scopes in scope builder?

Question

I am using ryanb-scope-builder and I am facing following issue.

def self.search(options)
  scope_builder do |builder|
    builder.released.visible
    builder.cheap if options[:cheap]
  end
end

This generates query which has :

builder.released.visible *AND* builder.cheap if options[:cheap]

Whereas I want scope to be OR'ed like

builder.released.visible *OR* builder.cheap if options[:cheap]

Is there any scope builder gem which can solve this problem ?? thanks

This question is duplicate of http://stackoverflow.com/questions/3005488/disjunction-in-activerecord — samuil, Aug 01 '11 at 09:02

score 2 · Accepted Answer · edited May 23 '17 at 09:58

2

I don't know this scope builder but generally, OR queries are made with Arel.

Besides, I doubt this gem is that useful:

edited May 23 '17 at 09:58

Community

answered Aug 01 '11 at 07:50

apneadiving

is it specific to rails 3 ? or 2.x can also use it ? – Anurag Aug 02 '11 at 10:36
got it.. can be used version independent. – Anurag Aug 02 '11 at 10:55

1 Answers1