Troubleshooting $search variable accessibility in Select Field modifyQueryUsing() method

Customizing the relationship query

You may customize the database query that retrieves options using the third parameter of the

relationship()

relationship()

method:

use Filament\Forms\Components\Select;
use Illuminate\Database\Eloquent\Builder;
 
Select::make('author_id')
   ->relationship(
        name: 'author',
        titleAttribute: 'name',
        modifyQueryUsing: fn (Builder $query) => $query->withTrashed(),
    )

use Filament\Forms\Components\Select;
use Illuminate\Database\Eloquent\Builder;
 
Select::make('author_id')
   ->relationship(
        name: 'author',
        titleAttribute: 'name',
        modifyQueryUsing: fn (Builder $query) => $query->withTrashed(),
    )

If you would like to access the current search query in the

modifyQueryUsing

modifyQueryUsing

function, you can inject

$search

$search

.

modifyQueryUsing

modifyQueryUsing

 Select::make('skills')
  ->multiple()
  ->relationship(
        titleAttribute: 'name',
        modifyQueryUsing: function (Builder $query, ?string $search) {
            return $query->withTrashed()
                ->where('name', 'LIKE', '%' . $search . '%')
                ->orderByRaw(
                    "CASE
                        WHEN name LIKE ? THEN 1
                        WHEN name LIKE ? THEN 2
                        ELSE 3
                    END, name ASC",
                    [$search . '%', '%' . $search . '%']
                )
                ->limit(20);
        }
    )

 Select::make('skills')
  ->multiple()
  ->relationship(
        titleAttribute: 'name',
        modifyQueryUsing: function (Builder $query, ?string $search) {
            return $query->withTrashed()
                ->where('name', 'LIKE', '%' . $search . '%')
                ->orderByRaw(
                    "CASE
                        WHEN name LIKE ? THEN 1
                        WHEN name LIKE ? THEN 2
                        ELSE 3
                    END, name ASC",
                    [$search . '%', '%' . $search . '%']
                )
                ->limit(20);
        }
    )

An attempt was made to evaluate a closure for [Filament\Forms\Components\Select], but [$search] was unresolvable.

$search

$search

modifyQueryUsing()

modifyQueryUsing()