FilamentF
Filament•3y ago
Falk Maria Zeitsprung

selectfilter from json data

I have a database filed where i have saved something like this:
[{"language":"german","language_level":"Native language"},{"language":"english","language_level":"Fluent \/ Fluent business"},{"language":"spanish","language_level":"Fluent \/ Fluent business"}]

Cane be one o n lines.

Now i need a SelectFilter where i can choose a language. And language_level (or language_level) withou selection.

I try:

SelectFilter::make('languages')
    ->options(['english' => 'Englisch', 'spanish' => 'Spanisch', 'french' => 'Französisch'])
    ->query(fn(Builder $query, $value): Builder => $query->whereJsonContains('languages')),
`
but get error: Unable to resolve dependency [Parameter #1 [ <required> $value ]] in class App\Filament\Resources\ApplicantResource
Solution
Try $state instead of $value
Jump to solution
Was this page helpful?