F
Filament•6d ago
sparmin

How to hide filter options and use only the search?

I've got a table with >60 k entries, thus the filter options of the select filter take a long time to load. Practically, I don't need the 60k options available in my select filter. All I will use is the search function. Is there a way to optimize load time? 
SelectFilter::make('number')
    ->label(__('filament.warranty_no'))
    ->options(
        Warranty::query()
            ->distinct('number')
            ->pluck('number', 'number'),
    )
    ->preload()
    ->searchable(),
SelectFilter::make('number')
    ->label(__('filament.warranty_no'))
    ->options(
        Warranty::query()
            ->distinct('number')
            ->pluck('number', 'number'),
    )
    ->preload()
    ->searchable(),
4 Replies
ChesterS
ChesterS•6d ago
Add a limit to your query? 
Warranty::query()
    ->distinct('number')
    ->limit(25)
    ->pluck('number', 'number'),
Warranty::query()
    ->distinct('number')
    ->limit(25)
    ->pluck('number', 'number'),
sparmin
sparminOP•6d ago
I need to be able to search through all options, adding the limit prevents that
toeknee
toeknee•6d ago
remove preload() so then only searching will return the right ones. and ensure you have an index for the number on the Warranty table.
ChesterS
ChesterS•6d ago
This won't work. '->pluck('name', 'number') will still run the query AFAIK. For example this ```php Select::make('contacts') ->options(fn() => Contact::query() ->limit(12345) ->pluck('name', 'id') ) ->preload(false) ->searchable(), ``` ends up in this query being executed on page load ```sql select name, id from contacts where contacts.deleted_at is null limit 12345 ``` The only way I've found that can avoid this is to either use a ->relationship() on the select (which is not alway possible) or run a custom results with ->getSearchResultsUsing()`

Did you find this page helpful?