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"}]

[{"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')),

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

$state

instead of

$value

$value

Jump to solution

Filament•3y ago•

32 replies

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"}]

[{"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')),

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

$state

instead of

$value

$value

Jump to solution

selectfilter from json data

selectfilter from json data

Similar Threads

Similar Threads

Similar Threads