Find all users with specific role using rolify

Question

How can i get all users with specific role when using rolify? I've tried the following but it didn't help:

User.with_role :admin

I get the following error:

NoMethodError: undefined method `with_role' for #<Class:0x0000000743f9c0>

Couldn't find any way to do this.

@GhostRider Other operations such ad adding a role to a user works properly. — roman, Jul 05 '12 at 17:35

Lookchin · Accepted Answer · 2012-12-13T18:10:39.760

32

You can use the with_role method with a User class to find all users who has a role in version 3.1.0.

User.with_role :admin

edited Dec 13 '12 at 18:10

answered Dec 12 '12 at 06:16

Lookchin

478
4
7

with "where" @courriers = User.where.not(latitude: nil, longitude:nil ).with_role :Courrier – Van Mart Feb 09 '17 at 23:00

score 9 · Answer 2 · answered Jul 05 '12 at 17:31

I'd ask the role for it's users

admins = Role.find_by_name('admin').users

the with_role method is for a particular user instance, not at the class-level for all users. If you want to implement that you'd have to do something like this:

#not 100% on this code, haven't tested it, but you get the idea.
User < ActiveRecord::Base
  def self.with_role(role)
     my_role = Role.find_by_name(role)
     where(:role => my_role)
  end
end

score 1 · Answer 3 · edited Jul 05 '12 at 18:21

1

Have you mentioned resourcify in the models in order to put roles on

class User < ActiveRecord::Base
  resourcify
end

With this you can use with_role and find_roles class methods.

edited Jul 05 '12 at 18:21

DVG

17,392
7
61
88

answered Jul 05 '12 at 17:34

Bijendra

9,467
8
39
66

Trying to do it like this gives the following: `User Load (0.3ms) SELECT `users`.* FROM `users` INNER JOIN "roles" ON "roles"."resource_type" = 'User' WHERE (roles.name = 'user' AND roles.resource_type = 'User') => #` – roman Jul 06 '12 at 09:42
This was an issue which has been fixed, just check this https://github.com/EppO/rolify/commit/da1ec59acda83b9114aeb410c99b1ce6e0866648 – Bijendra Jul 06 '12 at 09:53
Using resourcify in user model breaks succh methods as `all`, `first` etc. When i call User.all i get `NoMethodError: undefined method `find_or_create_by' for #` – roman Jul 06 '12 at 11:00
@innocent_rifle try to use rolify for User model and add roles using user instance. check https://github.com/EppO/rolify/issues/69 – Bijendra Jul 06 '12 at 11:54

score 1 · Answer 4 · answered Sep 12 '18 at 21:45

1

If you need to use joins, try this:

User.with_role(:admin).joins(:other_table).(other_table:{some_field: true})

answered Sep 12 '18 at 21:45

webaholik

1,619
1
19
30

score 0 · Answer 5 · answered Feb 09 '17 at 23:01

0

if you need an aditional "where"

@courriers = User.where.not(latitude: nil, longitude:nil ).with_role :Courrier

answered Feb 09 '17 at 23:01

Van Mart

3,002
1
10
5

Find all users with specific role using rolify

5 Answers5