/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

5 votes197 views5 answers
Laravel composer update
PHP Laravel
6 votes191 views1 answer
Debug query builder laravel
PHP Laravel
0 vote202 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
4 votes197 views2 answers
Laravel sum column values
PHP Laravel
0 vote230 views6 answers
Socialite laravel 7
PHP Laravel
2 votes205 views2 answers
Laravel sidebar menu active
PHP Laravel
1 vote237 views1 answer
Laravel images mimetypes validatiion
PHP Laravel
4 votes179 views5 answers
Laravel storage folder permissions
PHP Laravel
0 vote212 views3 answers
Laravel 7 upload file s3
PHP Laravel
2 votes187 views3 answers
Laravel many to many relationship with pivot table
PHP Laravel