cmaaccc Posts - Answer Overflow

cmaaccc

Posts Comments

FFilament

•Created by cmaaccc on 12/10/2023 in #❓┊help

Set default image src in FileEditor

16 replies

FFilament

•Created by cmaaccc on 10/5/2023 in #❓┊help

SelectFilter query not working as expected

I am on Filament version 3.0.68 I have the following select filter:

            ->filters([
                SelectFilter::make('division')
                    ->multiple()
                    ->native(false)
                    ->searchable()
                    ->options([
                      'NCAA D1',
                      'NCAA D2'
                    ])

            ])

            ->filters([
                SelectFilter::make('division')
                    ->multiple()
                    ->native(false)
                    ->searchable()
                    ->options([
                      'NCAA D1',
                      'NCAA D2'
                    ])

            ])

I expect to see filament query by 'NCAA D1' or 'NCAA D1', but I see this

select count(*) as aggregate from `college_programs` where `sport_id` in (25) and (`division` in ('0'))

select count(*) as aggregate from `college_programs` where `sport_id` in (25) and (`division` in ('0'))

Basically the index of the option is being passed in. This is what it looks like for a normal select filter:

select count(*) as aggregate from `college_programs` where `sport_id` in (25) and (`division` = '0')

select count(*) as aggregate from `college_programs` where `sport_id` in (25) and (`division` = '0')

Any ideas what I may be doing wrong?

4 replies

Gaming

Programming