FilamentF
Filament8mo ago
o.m

How to add custom sort query?

TextColumn::make('groups.status')
                ->label('Status')
                ->sortable()
                ->formatStateUsing(function ($state, $record) {
                    $groupUser = $record->groups->where('id', group()->id)->first()?->pivot;
                    return $groupUser ? ucfirst($groupUser->status) : 'Inactive';
                })
                ->extraAttributes(['style' => 'font-weight: bold'])
                ->color(function ($state, $record) {
                    $groupUserStatus = $record->groups->where('id', group()->id)->first()?->pivot?->status ?? 'inactive';
                    return $groupUserStatus === 'active' ? 'success' : 'secondary';
                })


How do I add custom sort for sortable() adding function ($query, $direction) causes An attempt was made to evaluate a closure for [Filament\Tables\Columns\TextColumn], but [$query] was unresolvable.

Just want to sort status based on asc or decending
Was this page helpful?