/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

4 votes136 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel
0 vote181 views1 answer
Delete folder laravel
PHP Laravel
5 votes194 views2 answers
Set unique value validation for laravel form request
PHP Laravel
7 votes183 views2 answers
Artisan in route in laravel
PHP Laravel
0 vote162 views1 answer
How push to array whit key in laravel
PHP Laravel
0 vote167 views2 answers
Laravel model column default value
PHP Laravel
6 votes173 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
0 vote126 views1 answer
Laravel get referer without host
PHP Laravel
1 vote193 views3 answers
Laravel multiple paginate
PHP Laravel
5 votes167 views5 answers
Laravel get all request parameters
PHP Laravel