Adding a SelectFilter with relationship breaks table ordering

I think this is a standard filament question but I'm using the plugin filament-auditing https://filamentphp.com/plugins/auditing and have extended the

AuditsRelationManager

AuditsRelationManager

to add a users filter.
https://github.com/TappNetwork/filament-auditing/blob/main/src/RelationManagers/AuditsRelationManager.php

->filters([
    Tables\Filters\SelectFilter::make('user_id')
        ->relationship('user', 'name') 
])

->filters([
    Tables\Filters\SelectFilter::make('user_id')
        ->relationship('user', 'name') 
])

But not sure why when I add this filter I get

Column not found: 1054 Unknown column 'name' in 'field list' (Connection: mysql, SQL: select
name
name
,
audits
audits
.
` from
` from
audits
order by
order by
name` asc)

Filament•3y ago•

2 replies

howdu

Adding a SelectFilter with relationship breaks table ordering

I think this is a standard filament question but I'm using the plugin filament-auditing https://filamentphp.com/plugins/auditing and have extended the

AuditsRelationManager

AuditsRelationManager

to add a users filter.
https://github.com/TappNetwork/filament-auditing/blob/main/src/RelationManagers/AuditsRelationManager.php

->filters([
    Tables\Filters\SelectFilter::make('user_id')
        ->relationship('user', 'name') 
])

->filters([
    Tables\Filters\SelectFilter::make('user_id')
        ->relationship('user', 'name') 
])

But not sure why when I add this filter I get

Column not found: 1054 Unknown column 'name' in 'field list' (Connection: mysql, SQL: select
name
name
,
audits
audits
.
` from
` from
audits
order by
order by
name` asc)

Adding a SelectFilter with relationship breaks table ordering

Similar Threads

Adding a SelectFilter with relationship breaks table ordering

Similar Threads

Similar Threads

Similar Threads