/PHP/Laravel/Laravel get all users except role spatie

Laravel get all users except role spatie

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

1) Users who dont have any role.

User::whereDoesntHave('roles')->get();

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

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

Similar codes

0 vote286 views1 answer
Remove invalid characters from a string laravel
PHP Laravel
0 vote228 views1 answer
Laravel blade trim whitespace
PHP Laravel
0 vote268 views1 answer
Laravel list unique indexes
PHP Laravel
0 vote256 views1 answer
Laravel request except multiple
PHP Laravel
11 votes251 views3 answers
Laravel auth 6
PHP Laravel
8 votes248 views6 answers
Laravel session
PHP Laravel
0 vote217 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote260 views1 answer
Laravel validation unique if this field is changed
PHP Laravel
1 vote255 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
0 vote261 views1 answer
How to read laravel query string with dash
PHP Laravel