SelectFilter doesn not work like I want

Hello I have a select filter

Tables\Filters\SelectFilter::make('status_filter')
  ->options(JobStatusEnum::asSelectArray())
  ->modifyQueryUsing(function (mixed $state, Builder $query): Builder {
    return $query->where('status', $state);
  }),

Tables\Filters\SelectFilter::make('status_filter')
  ->options(JobStatusEnum::asSelectArray())
  ->modifyQueryUsing(function (mixed $state, Builder $query): Builder {
    return $query->where('status', $state);
  }),

And it's work, but when I not have any selected option I dont have a any record in table. How I can fix them?

Solution

I think you can use

$query->when(..)

$query->when(..)

like this example

Custom filters - Table Builder - Filament

Jump to solution

Filament•13mo ago•

5 replies

__Dementor

SelectFilter doesn not work like I want

Hello I have a select filter

Tables\Filters\SelectFilter::make('status_filter')
  ->options(JobStatusEnum::asSelectArray())
  ->modifyQueryUsing(function (mixed $state, Builder $query): Builder {
    return $query->where('status', $state);
  }),

Tables\Filters\SelectFilter::make('status_filter')
  ->options(JobStatusEnum::asSelectArray())
  ->modifyQueryUsing(function (mixed $state, Builder $query): Builder {
    return $query->where('status', $state);
  }),

And it's work, but when I not have any selected option I dont have a any record in table. How I can fix them?

Solution

I think you can use

$query->when(..)

$query->when(..)

like this example

Custom filters - Table Builder - Filament

Jump to solution

SelectFilter doesn not work like I want

SelectFilter doesn not work like I want

Similar Threads

Similar Threads

Similar Threads