FilamentF
Filament•16mo ago
theageddeveloper

How to use table filters in getEloquentQuery?

Hi,
is there possibility to use filters inside getEloquentQuery? I have custom case with big query inside getEloquentQuery method, that has sub queries inside and my select filter would have to add where conditions to my subqueries.
I tried to do something like this:
public static function table(Table $table): Table
    {
             ->filters([
                SelectFilter::make('game')
                    ->label('Game')
                    ->options(GameEnum::class)
                     ->query(function ($query) {
                     })
            ])
 }
 
  #[Override]
    public static function getEloquentQuery(): Builder
    {
        $tableFilters = request()->query('tableFilters');
        $game = isset($tableFilters['game']['value']) ? $tableFilters['game']['value'] : null;

        return parent::getEloquentQuery()
            ->select('users.*')
            ->leftJoinSub(
                \DB::table('othertable')
                    ->select('custom_column_id', \DB::raw('COUNT(*) as count'))
                    ->when($game, function ($query, $game) {
                        $query->where('enquiry->game', $game);
                    })
                    ->groupBy('custom_column_id'),
                'counts',
                function ($join) {
                    $join->on('users.id', '=', 'counts.match_id');
                }
            )
            .....

In this case $game parameter is set on initial load but later on is null despite being present in the url. Probably it is being cleared.
How to handle such complex cases?
Was this page helpful?