List users not belongs to a role

Question

I use laravel spatie package for user permissions. I need to list all users not belongs to a specific user. For example list all non admin(role) users.

For listing all admin users I used

$users = App\User::role('admin');

I need just opposite to that

@AdamKozlowski, Other users didn't belong to any role. So I got the result by `$users = User::whereDoesntHave('roles')->get();` — Haris, Apr 23 '18 at 19:15

score 6 · Accepted Answer · answered Apr 23 '18 at 09:56

6

Try that way:

return $this->users()->whereHas('roles', function ($query) {
    return $query->where('name','!=', 'admin');
})->first();

answered Apr 23 '18 at 09:56

Adam Kozlowski

5,606
2
32
51

score 3 · Answer 2 · edited Mar 17 '20 at 17:18

3

You can make 2 querys to get both groups of users that you want. I mean:

1 ) Users who don't have any role.

User::whereDoesntHave('roles')->count()

2 ) Users have any role, but not admin (from Adam Kozlowski answer)

$this->users()->whereHas('roles', function ($query) {
    $query->where('name','!=', 'admin');
})->first();

edited Mar 17 '20 at 17:18

matthias_h

11,356
9
22
40

answered Mar 17 '20 at 16:45

Pedro Scarselletta

31
3

score 1 · Answer 3 · answered Apr 23 '18 at 09:55

As its documentation states you can use:

$users = User::role('writer')->get(); // Returns only users with the role 'writer'

The role scope can accept a string, a \Spatie\Permission\Models\Role object or an \Illuminate\Support\Collection object.

Just put the roles you want to query in a collection.

List users not belongs to a role

3 Answers3