Eloquent Builder with relationships

I could use $user->hasRole('admin') to identify admins. But filament uses query builder for generating tables: parent::getEloquentQuery().
How do I make it so that parent::getEloquentQuery would generate table with only admin records? ->with('roles') isn't working.
(I am using spatie permissions)

Dan Harrin•6/17/23, 4:55 PM

is it a users table or something?

Dan Harrin•6/17/23, 4:57 PM

from their own docs

PositiverainOP•6/17/23, 5:08 PM

yeh it is a users table, which is some how linked to roles table..
I am talking about this function from the user resource
public static function getEloquentQuery(): Builder {....}
which builds the table,
Usually there is
return parent::getEloquentQuery();
But I want only admins to be shown on the table

Dan Harrin•6/17/23, 5:09 PM

yup, their docs explain how to do this

Dan Harrin•6/17/23, 5:09 PM

please read the screenshot i sent

PositiverainOP•6/17/23, 5:25 PM

yeh it does work with finding only admins, but what if i want multiple roles?
return User::role('admin'); works, but i also want to show the users along with admin
return User::role(['admin','user']); doesn't work

PositiverainOP•6/18/23, 6:02 AM

Nvm I used parent::getEloquentQuery()->whereHas('roles', function($q) { return $q after where} and it fixed the problem