FilamentF
Filament•3y ago
Colin

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'
                    ])

            ])


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'))

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')


Any ideas what I may be doing wrong?
Solution
Apparently my issue was that I needed to pass key / value for options. 🤦‍♀️
Jump to solution
Was this page helpful?