Filament•2mo ago

Soft deleted records don't show after applying filter

I'm having weird problem with filament, I have 4 soft deleted profiles and added a filter to show them in ProfileResource, but none are getting shown in table, if I dd the query it's also showing correct SQL for return $query->onlyTrashed(): Sql dump:

"select * from `profiles` where `profiles`.`deleted_at` is not null and `profiles`.`account_id` in (?)" // app/Filament/App/Resources/ProfileResource.php:327

array:1 [▼ // app/Filament/App/Resources/ProfileResource.php:327
  0 => 422
]

"select * from `profiles` where `profiles`.`deleted_at` is not null and `profiles`.`account_id` in (?)" // app/Filament/App/Resources/ProfileResource.php:327

array:1 [▼ // app/Filament/App/Resources/ProfileResource.php:327
  0 => 422
]

ProfileResource.php

->filters([
    Tables\Filters\Filter::make('Trashed')
        ->query(fn ($query) => ( dd($query->onlyTrashed()->toSql(), $query->getBindings() )))
        ->label('Trashed')
        ->toggle()
])

->filters([
    Tables\Filters\Filter::make('Trashed')
        ->query(fn ($query) => ( dd($query->onlyTrashed()->toSql(), $query->getBindings() )))
        ->label('Trashed')
        ->toggle()
])

1 Reply

lukaveck1OP•2mo ago

Solved with: https://filamentphp.com/docs/3.x/tables/filters/ternary#filtering-soft-deletable-records

Ternary filters - Table Builder - Filament

Gaming

Programming

Soft deleted records don't show after applying filter