Filament•11mo ago

How can I add filtering by name field?

       Filter::make('name')
                ->form([
                    Forms\Components\Select::make('name'),
                ])
                    ->query(function (Builder $query, array $data): Builder {
                        $nameFilter = $data['name'];

                        if ($nameFilter) {
                            return $query->where('name', 'like', "%$nameFilter%");
                        }

                        return $query;
                    })

       Filter::make('name')
                ->form([
                    Forms\Components\Select::make('name'),
                ])
                    ->query(function (Builder $query, array $data): Builder {
                        $nameFilter = $data['name'];

                        if ($nameFilter) {
                            return $query->where('name', 'like', "%$nameFilter%");
                        }

                        return $query;
                    })

"I would like to perform filtering based on the 'name' field. However, in the Select input, I want to first list these options. Once an option is selected from the list, I want it to be used as a filter. The provided code didn't fulfill my needs accurately."

2 Replies

LeandroFerreira•11mo ago

Not sure

SelectFilter::make('name')
    ->multiple()
    ->options(YourModel::distinct()->pluck('name', 'name'))

SelectFilter::make('name')
    ->multiple()
    ->options(YourModel::distinct()->pluck('name', 'name'))

Mehmet K.•11mo ago

Thank you it's work 🙂

Gaming

Programming

How can I add filtering by name field?