Level 102
$users = User::role('employee')->get();
If I recall correctly
Sep 26, 2022
3
Level 1
Query Users according to specific role (Laravel Spatie)
Hello, I have a really simple question and I am stuck on it. How can I get users that have only a specific role? i.e. I want to query users that have an "employee" role only but in general, they can have multiple roles. Example: User 1 - Employee - Accounts User 2 - Employee
In this example, I only want user 2.
Level 1
@Sinnbeck Nope this fetches all users even though they have multiple roles,
Level 102
@SalmanMalik ah ok got it. Try this
$users = User::whereHas('roles', function ($query) {
$query->where('name', 'employee');
}, 1)->get();
Please or to participate in this conversation.