Thanks for reporting this! We'll get this fixed up for the next release.

The same is true for with_all_roles. Is there any workaround?

You can combine ActiveRecord relations using .merge that combines WHERE clauses using AND which is not helping in that case (we need to OR the different WHERE clauses). With the upcoming Rails 5 release, we will be able to combine two ActiveRecord relation with OR (read this article for more info). I don't see any workaround for Rails <=4.x except playing with Arel directly.

Has there been any progress on this? I was really hopeful that this method would do exactly what I wanted, but then I saw it was an array, which prevented me from chaining it with other queries.

Alright, I figured out a way to fix this method. I've got a PR open now (#441)

workaround

# user.rb
scope :with_any_roles, ->(names) do
  joins(:roles).where("roles.name IN (?)", names)
end

# using
User = User.with_any_roles([:admin, :moderator])

@nhattan If user has multiple roles, then with that query you will get duplicate rows. Of course User.with_any_roles([:admin, :moderator]).distincthelps

Still not released?

Thanks @kakoni

Any update on this?

WIP here #441

TL;DR: Works with Rails 4.2 but not (yet) on Rails 5

@kakoni just be aware that the workaround does not work when there is a column with type json. DISTINCT raises an exception in that case.

@kakoni @nhattan Maybe it is safer to write it as:

# user.rb
scope :with_any_roles, ->(names) do
  where(id: joins(:roles).select('users.id').distinct.where("roles.name IN (?)", names))
end

@milani - I'm using your code right now and it works like a charm.

Still waiting for this feature in a Gem

It would be best if all role queries returned an AR, not an Array.

6 years 🥇