How to get current filter value in getEloquentQuery() function?

[wpas81]

Package

Table builder

Package Version

v3.2.98

How can we help you?

I've got a Resource Page where I want to add some Raw query syntax based upon the value of the current selected table filter.
The filter itself works just fine & the url of the page gets updated with the current filter values
eg https://mysite/.../mypage?tableFilters[activity_id][value]=12

in the getEloquentQuery function I can't retrieve the current value.
$id gets the value
Closure($livewire) {#2479 ▼ // app/Filament/Resources/MyResource.php:30 class: " App\Filament\Resources \ MyResource" }

How can I resolve this?

` public static function getEloquentQuery(): Builder
{
$id = (fn ($livewire) => data_get($livewire->tableFilters, 'activity_id.value') ?? 0);

    return parent::getEloquentQuery()
       ->select('id', 'name', \DB::raw("$id as test"));
}

public static function table(Table $table): Table
{
return $table

        ->columns([
            Tables\Columns\TextColumn::make('id')
                ->label('Naam'),
            Tables\Columns\TextColumn::make('name')
                ->label('Type'),
            Tables\Columns\TextColumn::make('test')
                ->label('Type')
        ])
        ->filters([
            Tables\Filters\SelectFilter::make('activity_id')
                ->options(
                    Activity::select('id','title')
                        ->orderBy('start', 'desc')
                        ->get()
                        ->pluck('title', 'id')
                )
            ->default(function() {
                $latest = Activity::select('id', 'title')->whereDate('start', '>=', \Carbon\Carbon::today())->orderBy('start', 'asc')->first();
                return $latest ? $latest->id : null;
            }),
        ], layout: FiltersLayout::AboveContent)
        ->filtersFormColumns(3)           
}

`