F
Filament•15mo ago
Atena.D

How to filter Filament table by nested relationship?

The structure of tables are like this: acc->user->role
now I'm in acc resource and I want to filter the rows based on user roles. How can I do that?
5 Replies
LeandroFerreira
LeandroFerreira•15mo ago
Atena.D
Atena.D•15mo ago
I added this. then how should my code be like? I tried this: SelectFilter::make('user.role') ->options(UsersRoles::all()->pluck('role', 'id')) ->label('user role'), but didnt work
LeandroFerreira
LeandroFerreira•15mo ago
ahh, ok. You can use: 
SelectFilter::make('roles')
->options(UsersRoles::pluck('role', 'id'))
->label('user role')
->query(function (Builder $query, array $data) {
    //return $query...
})
SelectFilter::make('roles')
->options(UsersRoles::pluck('role', 'id'))
->label('user role')
->query(function (Builder $query, array $data) {
    //return $query...
})
and return the query with the filters... Other example here https://filamentphp.com/docs/2.x/tables/filters#custom-filter-forms
Filament
Filters - Table Builder - Filament
The elegant TALL stack table builder for Laravel artisans.
LeandroFerreira
LeandroFerreira•15mo ago
Are you using the Spatie package to manage roles/permissions? 
SelectFilter::make('roles')
    ->relationship('roles', 'name')
SelectFilter::make('roles')
    ->relationship('roles', 'name')
Atena.D
Atena.D•15mo ago
No actually these roles are a little bit different. but I'm now able to do that using whereHas in the query. Thanks!
Want results from more Discord servers?
Add your server
More Posts
Is there any way to ask user confirmation before file is removed from FileUpload field?I did not find any way to to ask the user a confirmation pop up when user click on `X` icon in the fspaite tags for filaments CURD operationsAre there any tutorials or solutions available for creating a Laravel resource for managing spaite tAnyone created a BPMN with Filament?Currently building a BPMN and looking for inspiration if anyone has previously created onehow to mutate data in record in relation in formI have a userResource for User table which has a metadata table with its foreign-key. I have addedShow DB notifications unread button/icon in admin panelHello, I want to use the DB notifications https://filamentphp.com/docs/2.x/notifications/database-noLazy file uploadsI have a form with multiple file upload fields. Since all files are immediately uploaded to LivewirChange input label dynamicallyHi! How can i change an Input Label according the another field/select/radio selected value? For exUse a custom view for overview card widgetHow to use a custom view for an overview widget?conditionally showing relationship.Hey all, I'm using the table builder. I have a model Customer that has a many to many relationship Custom query for repeaterHi everyone. Is it possible to create custom query for repeater?