blocks|key|932687|text|你会这么做的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|932688|Person.where('name=?+OR+lastname=?',+'John',+'Smith')|code-block|syntax|javascript|932689|现在，新的AR3语法没有任何其他的OR支持(也就是说，没有使用第三方gem)。|932690|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You would do

<pre><code>Person.where('name=? OR lastname=?', 'John', 'Smith')
</code></pre>

Right now, there isn't any other OR support by the new AR3 syntax (that is without using some 3rd party gem).

blocks|key|1147133|text|使用ARel|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1147134|t+=+Person.arel_table

results+=+Person.where(
++t[:name].eq("John").
++or(t[:lastname].eq("Smith"))
)|code-block|syntax|javascript|1147135|entityMap|0|LINK|mutability|MUTABLE|url|http://github.com/rails/arel^0|2|4|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Use <a href="http://github.com/rails/arel" rel="noreferrer">ARel</a>

<pre><code>t = Person.arel_table

results = Person.where(
 t[:name].eq("John").
 or(t[:lastname].eq("Smith"))
)
</code></pre>

blocks|key|1147163|text|你也可以使用SQL来避免把你的代码和MetaWhere混在一起：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1147164|Person.where((:name+=>+"John")+%7C+(:lastname+=>+"Smith"))|code-block|syntax|javascript|1147165|entityMap|0|LINK|mutability|MUTABLE|url|http://metautonomo.us/projects/metawhere/^0|I|9|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

You can also use <a href="http://metautonomo.us/projects/metawhere/" rel="noreferrer">MetaWhere</a> gem to not mix up your code with SQL stuff:

<pre><code>Person.where((:name =&gt; "John") | (:lastname =&gt; "Smith"))
</code></pre>

blocks|key|932802|text|如果你使用的是Rails+3.0%2B，这将是MetaWhere的一个很好的候选者，但是它不能在Rails+3.1上工作。您可能想尝试一下squeel。它是由同一个作者制作的。下面是如何执行基于OR的链的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|932803|Person.where{(name+==+"John")+%7C+(lastname+==+"Smith")}|code-block|syntax|javascript|932804|您可以在许多其他awesome+things中混合和匹配AND/OR。|932805|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/ernie/squeel|1^0|1V|6|0|0|0|8|E|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|K|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|R]]]]

This would be a good candidate for MetaWhere if you're using Rails 3.0+, but it doesn't work on Rails 3.1. You might want to try out <a href="https://github.com/ernie/squeel" rel="nofollow noreferrer">squeel</a> instead. It's made by the same author. Here's how'd you'd perform an OR based chain:

<pre><code>Person.where{(name == "John") | (lastname == "Smith")}
</code></pre>

You can mix and match AND/OR, among many other <a href="https://github.com/ernie/squeel" rel="nofollow noreferrer">awesome things</a>.

blocks|key|1147239|text|names+=+["tim",+"tom",+"bob",+"alex"]
sql_string+=+names.map+{+%7Ct%7C+"name+=+'#{t}'"+}.join("+OR+")
@people+=+People.where(sql_string)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1147240|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>names = ["tim", "tom", "bob", "alex"]
sql_string = names.map { |t| "name = '#{t}'" }.join(" OR ")
@people = People.where(sql_string)
</code></pre>

blocks|key|1147324|text|如果任何人正在寻找这个问题的更新答案，看起来有一个现有的pull请求将其放入Rails：https://github.com/rails/rails/pull/9052。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1147325|感谢@j-mcnally的ActiveRecord+(https://gist.github.com/j-mcnally/250eaaceef234dd8971b)猴子补丁，你可以做以下事情：|1147326|Person.where(name:+'John').or.where(last_name:+'Smith').all|code-block|syntax|javascript|1147327|更有价值的是能够用OR链接作用域|style|CODE|1147328|scope+:first_or_last_name,+->(name)+{+where(name:+name.split('+').first).or.where(last_name:+name.split('+').last)+}
scope+:parent_last_name,+->(name)+{+includes(:parents).where(last_name:+name)+}|1147329|然后，您可以查找所有具有名字或姓氏或其父母具有姓氏的人员|1147330|Person.first_or_last_name('John+Smith').or.parent_last_name('Smith')|1147331|这不是使用这个的最好例子，但只是尝试将其与问题相匹配。|1147332|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/rails/rails/pull/9052|1|https://gist.github.com/j-mcnally/250eaaceef234dd8971b^0|18|14|0|0|R|1I|1|0|0|9|2|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]]|C|$]]|$1|D|3|E|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|F|3|G|5|H|7|1E|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|1F|8|@$A|1G|B|1H|M|N]]|9|@]|C|$]]|$1|O|3|P|5|H|7|1I|8|@]|9|@]|C|$I|J]]|$1|Q|3|R|5|6|7|1J|8|@]|9|@]|C|$]]|$1|S|3|T|5|H|7|1K|8|@]|9|@]|C|$I|J]]|$1|U|3|V|5|6|7|1L|8|@]|9|@]|C|$]]|$1|W|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]]|X|$Y|$5|Z|10|11|C|$12|13]]|14|$5|Z|10|11|C|$12|15]]]]

In case anyone is looking for an updated answer to this one, it looks like there is an existing pull request to get this into Rails: <a href="https://github.com/rails/rails/pull/9052">https://github.com/rails/rails/pull/9052</a>.

Thanks to @j-mcnally's monkey patch for ActiveRecord (<a href="https://gist.github.com/j-mcnally/250eaaceef234dd8971b">https://gist.github.com/j-mcnally/250eaaceef234dd8971b</a>) you can do the following:

<pre><code>Person.where(name: 'John').or.where(last_name: 'Smith').all
</code></pre>

Even more valuable is the ability to chain scopes with <code>OR</code>:

<pre><code>scope :first_or_last_name, -&gt;(name) { where(name: name.split(' ').first).or.where(last_name: name.split(' ').last) }
scope :parent_last_name, -&gt;(name) { includes(:parents).where(last_name: name) }
</code></pre>

Then you can find all Persons with first or last name or whose parent with last name

<pre><code>Person.first_or_last_name('John Smith').or.parent_last_name('Smith')
</code></pre>

Not the best example for the use of this, but just trying to fit it with the question.

blocks|key|932987|text|squeel+gem提供了一种非常简单的方法来实现这一点(在此之前，我使用了类似@coloradoblue的方法)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|932988|names+=+["Kroger",+"Walmart",+"Target",+"Aldi"]
matching_stores+=+Grocery.where{name.like_any(names)}|code-block|syntax|javascript|932989|entityMap^0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

the <code>squeel</code> gem provides an incredibly easy way to accomplish this (prior to this I used something like @coloradoblue's method):

<pre><code>names = ["Kroger", "Walmart", "Target", "Aldi"]
matching_stores = Grocery.where{name.like_any(names)}
</code></pre>

blocks|key|933077|text|如果你不能手动写出where子句来包含"or“语句(例如，你想组合两个作用域)，你可以使用union：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933078|Model.find_by_sql("#{Model.scope1.to_sql}+UNION+#{Model.scope2.to_sql}")|code-block|syntax|javascript|933079|(来源：ActiveRecord+Query+Union)|offset|length|933080|这将返回与任一查询匹配的所有记录。但是，这将返回一个数组，而不是一个arel。如果你真的想要返回一个arel，你可以看看这个要点：https://gist.github.com/j-mcnally/250eaaceef234dd8971b。|933081|只要你不介意猴子修补rails，这就可以完成这项工作。|933082|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/6686920/activerecord-query-union|1|https://gist.github.com/j-mcnally/250eaaceef234dd8971b^0|0|0|4|O|0|0|1T|1I|1|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]]|A|$]]|$1|K|3|L|5|6|7|14|8|@]|9|@$I|15|J|16|1|17]]|A|$]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

If you can't write out the where clause manually to include the "or" statement (ie, you want to combine two scopes), you can use union:

<pre><code>Model.find_by_sql("#{Model.scope1.to_sql} UNION #{Model.scope2.to_sql}")
</code></pre>

(source: <a href="https://stackoverflow.com/questions/6686920/activerecord-query-union">ActiveRecord Query Union</a>)

This is will return all records matching either query. However, this returns an array, not an arel. If you really want to return an arel, you checkout this gist: <a href="https://gist.github.com/j-mcnally/250eaaceef234dd8971b" rel="nofollow noreferrer">https://gist.github.com/j-mcnally/250eaaceef234dd8971b</a>. 

This will do the job, as long as you don't mind monkey patching rails.

blocks|key|933087|text|Rails+4|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933088|scope+:combined_scope,+->+{+where("name+=+?+or+name+=+?",+'a',+'b')+}|code-block|syntax|javascript|933089|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Rails 4

<pre><code>scope :combined_scope, -&gt; { where("name = ? or name = ?", 'a', 'b') }
</code></pre>

blocks|key|1147507|text|Rails+4%2B+Scope+%2B+Arel|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1147508|class+Creature+<+ActiveRecord::Base
++++scope+:is_good_pet,+->+{
++++++++where(
++++++++++++arel_table[:is_cat].eq(true)
++++++++++++.or(arel_table[:is_dog].eq(true))
++++++++++++.or(arel_table[:eats_children].eq(false))
++++++++)
++++}
end|code-block|syntax|javascript|1147509|我试着用.or链接命名的作用域，但没有成功，但这能找到那些布尔值集合的任何东西。生成SQL，如|1147510|SELECT+'CREATURES'.*+FROM+'CREATURES'+WHERE+((('CREATURES'.'is_cat'+=+1+OR+'CREATURES'.'is_dog'+=+1)+OR+'CREATURES'.'eats_children'+=+0))|1147511|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Rails 4 + Scope + Arel

<pre><code>class Creature &lt; ActiveRecord::Base
 scope :is_good_pet, -&gt; {
 where(
 arel_table[:is_cat].eq(true)
 .or(arel_table[:is_dog].eq(true))
 .or(arel_table[:eats_children].eq(false))
 )
 }
end
</code></pre>

I tried chaining named scopes with .or and no luck, but this worked for finding anything with those booleans set. Generates SQL like

<pre><code>SELECT 'CREATURES'.* FROM 'CREATURES' WHERE ((('CREATURES'.'is_cat' = 1 OR 'CREATURES'.'is_dog' = 1) OR 'CREATURES'.'eats_children' = 0))
</code></pre>

blocks|key|933188|text|Rails/ActiveRecord的更新版本可能本机支持此语法。它看起来类似于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933189|Foo.where(foo:+'bar').or.where(bar:+'bar')|code-block|syntax|javascript|933190|如此拉取请求https://github.com/rails/rails/pull/9052中所述|offset|length|933191|就目前而言，只要坚持以下几点就行了：|933192|Foo.where('foo=+?+OR+bar=+?',+'bar',+'bar')|933193|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/rails/rails/pull/9052^0|0|0|6|14|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

An updated version of Rails/ActiveRecord may support this syntax natively. It would look similar to:

<pre><code>Foo.where(foo: 'bar').or.where(bar: 'bar')
</code></pre>

As noted in this pull request <a href="https://github.com/rails/rails/pull/9052">https://github.com/rails/rails/pull/9052</a>

For now, simply sticking with the following works great:

<pre><code>Foo.where('foo= ? OR bar= ?', 'bar', 'bar')
</code></pre>

blocks|key|933234|text|对于我来说(Rails+4.2.5)，它只是这样工作的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933235|{+where("name+=+?+or+name+=+?",+a,+b)+}|code-block|syntax|javascript|933236|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For me (Rails 4.2.5) it only works like this:

<pre><code>{ where("name = ? or name = ?", a, b) }
</code></pre>

blocks|key|933277|text|根据this+pull+request的说法，Rails+5现在支持以下用于链接查询的语法：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|933278|Post.where(id:+1).or(Post.where(id:+2))|code-block|syntax|javascript|933279|还可以通过this+gem.将该功能反向移植到Rails4.2中|933280|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/rails/rails/pull/16052|1|https://github.com/Eric-Guo/where-or^0|2|H|0|0|0|5|9|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

According to <a href="https://github.com/rails/rails/pull/16052" rel="noreferrer">this pull request</a>, Rails 5 now supports the following syntax for chaining queries:

<pre><code>Post.where(id: 1).or(Post.where(id: 2))
</code></pre>

There's also a backport of the functionality into Rails 4.2 via <a href="https://github.com/Eric-Guo/where-or" rel="noreferrer">this gem.</a>

blocks|key|933415|text|因此，原始问题的答案似乎是“不能”，你能用'or‘代替'and’连接作用域吗？但你可以手动编写一个完全不同的作用域或查询来完成这项工作，或者使用来自ActiveRecord的不同框架，例如MetaWhere或Squeel。在我的情况下没有用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933416|我正在“或”一个由pg_search生成的作用域，它比select做得更多，它包括order+by+ASC，这把一个干净的联合搞得一团糟。我想用一个手工作用域“或”它来做一些我在pg_search中做不到的事情。所以我不得不这样做。|933417|Product.find_by_sql("(#{Product.code_starts_with('Tom').to_sql})+union+(#{Product.name_starts_with('Tom').to_sql})")|code-block|syntax|javascript|933418|例如，将作用域转换为sql，用括号括起每个作用域，并将它们合并在一起，然后使用生成的sql进行find_by_sql。这有点垃圾，但它确实有效。|933419|不，不要告诉我我可以在pg_search中使用“hstore：:name，:code”，我想这样做，但是'name‘字段是一个hstore，pg_search还不能处理。因此，必须手工创建名称的作用域，然后将其与pg_search作用域联合。|933420|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

So the answer to the original question, can you join scopes with 'or' instead of 'and' seems to be "no you can't". But you can hand code a completely different scope or query that does the job, or use a different framework from ActiveRecord e.g. MetaWhere or Squeel. Not useful in my case

I'm 'or'ing a scope generated by pg_search, which does a bit more than select, it includes order by ASC, which makes a mess of a clean union. I want to 'or' it with a handcrafted scope that does stuff I can't do in pg_search. So I've had to do it like this.

<pre><code>Product.find_by_sql("(#{Product.code_starts_with('Tom').to_sql}) union (#{Product.name_starts_with('Tom').to_sql})")
</code></pre>

I.e. turn the scopes into sql, put brackets around each one, union them together and then find_by_sql using the sql generated. It's a bit rubbish, but it does work.

No, don't tell me I can use "against: [:name,:code]" in pg_search, I'd like to do it like that, but the 'name' field is an hstore, which pg_search can't handle yet. So the scope by name has to be hand crafted and then unioned with the pg_search scope.

blocks|key|933469|text|如果您希望提供一个作用域(而不是显式地处理整个数据集)，下面是您应该使用Rails5做的事情：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933470|scope+:john_or_smith,+->+{+where(name:+"John").or(where(lastname:+"Smith"))+}|code-block|syntax|javascript|933471|或者：|933472|def+self.john_or_smith
++where(name:+"John").or(where(lastname:+"Smith"))
end|933473|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you're looking to provide a scope (instead of explicitly working on the whole dataset) here's what you should do with Rails 5:

<pre><code>scope :john_or_smith, -&gt; { where(name: "John").or(where(lastname: "Smith")) }
</code></pre>

Or:

<pre><code>def self.john_or_smith
 where(name: "John").or(where(lastname: "Smith"))
end
</code></pre>

blocks|key|1147948|text|这是一种非常方便的方式，它在Rails+5中运行良好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1147949|Transaction
++.where(transaction_type:+["Create",+"Correspond"])
++.or(
++++Transaction.where(
++++++transaction_type:+"Status",
++++++field:+"Status",
++++++newvalue:+["resolved",+"deleted"]
++++)
++)
++.or(
++++Transaction.where(transaction_type:+"Set",+field:+"Queue")
++)|code-block|syntax|javascript|1147950|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is a very convenient way and it works fine in Rails 5:

<pre><code>Transaction
 .where(transaction_type: ["Create", "Correspond"])
 .or(
 Transaction.where(
 transaction_type: "Status",
 field: "Status",
 newvalue: ["resolved", "deleted"]
 )
 )
 .or(
 Transaction.where(transaction_type: "Set", field: "Queue")
 )
</code></pre>

blocks|key|933572|text|我现在正在使用Rails+6，看起来这是可能的。使用来自OP的查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933573|#+in+the+Person+model:
scope+:john,+->+{+where(name:+"John")+}
scope+:smith,+->+{+where(lastname:+"Smith")+}
scope+:john_or_smith,+->+{+john.or(self.smith)+}|code-block|syntax|javascript|933574|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I'm working in Rails 6 now and it seems like this is now possible. Using the queries from the OP:
<pre><code># in the Person model:
scope :john, -&gt; { where(name: &quot;John&quot;) }
scope :smith, -&gt; { where(lastname: &quot;Smith&quot;) }
scope :john_or_smith, -&gt; { john.or(self.smith) }
</code></pre>

I'm using Rails3, ActiveRecord

Just wondering how can I chain the scopes with OR statements rather than AND.

e.g. 

<pre><code>Person.where(:name =&gt; "John").where(:lastname =&gt; "Smith")
</code></pre>

That normally returns:

<pre><code>name = 'John' AND lastname = 'Smith'
</code></pre>

but I'd like: 

<pre><code>`name = 'John' OR lastname = 'Smith'
</code></pre>

How to chain scope queries with OR instead of AND?

我使用的是Rails3、ActiveRecord我想知道如何使用OR语句而不是AND语句来链接作用域。例如：Person.where(:name => "John").where(:lastname => "Smith")它通常会返回：name = 'John' AND lastname = 'Smith'但我想说：`...

问如何用OR代替AND来链接作用域查询？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用OR代替AND来链接作用域查询？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用OR代替AND来链接作用域查询？
EN