Select Field Multiple Searching
I have a select multiple field on my Media Resource, with a dropdown to select from the Products table.
My Media model has uses a relationship to my Product model. My Product model is quite large, but nothing I can do about that at this stage as it has a lot of different fields.
I can see it can take up to 15 seconds to get a response for the user when they type a phrase into the search.
I am already using:
->searchable(['admin_designation', 'sku'])
->searchDebounce(2000)
->optionsLimit(5)
Looking at Laravel Debugbar, I can see that the query is actually returning all the product fields, not just the fields that are being searched.
"select distinct
product.* from product left join media_product on product.id = media_product.product_id where (admin_name like '%937031%') and product.deleted_at is null order by product.admin_name asc limit 5"
Within MySQL, I can speed the query up significantly by only returning product.sku, or product.id, so I suspect actually it's Filament or Livewire trying to load the data into the browser which is slowing us down - a request is around 35 mb.
Is there a way to limit the underlying search query on a select multiple to speed up the search, does anyone know please?10 Replies
the
Select field is generally very customisable.
Not sure what your setup is, but you can override the whole search query.
Have a look here
https://filamentphp.com/docs/3.x/forms/fields/select#returning-custom-search-resultsAll you need for the select to work is an array with a key and a value, so as long as you provide that, it should be fine
That is much lighter @ChesterS 🙂 Cheers
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
Using...
->getSearchResultsUsing(fn (string $search): array => Technology::where('name', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')->toArray())
->getOptionLabelsUsing(fn (array $values): array => Technology::whereIn('id', $values)->pluck('name', 'id')->toArray()),
example...
Interestingly, it sped up the searching by almost 90%....!
But then the relationships never saved!
Hmm that's weird. Those changes should not affect anything else 🤔 Anything else that might be affecting this?
@ChesterS this finally worked....!
My challenge is getting the dropdown label to now display two fields with a hyphen between them. The value saves, and when refreshed, in the list it shows both fields, but not on the dropdown
@LeandroFerreira @ChesterS I thought so too...but I get an error using:
->getSearchResultsUsing(fn (string $search): array => Product::where('admin_name', 'like', "%{$search}%")->orWhere('sku', 'like', "%{$search}%")->limit(10)->pluck('admin_name', 'id')->toArray())
->getOptionLabelFromRecordUsing(fn ($value): ?string => Product::find($value)?->sku)
"An attempt was made to evaluate a closure for [Filament\Forms\Components\Select], but [$value] was unresolvable."
Even when using a select multiple() field, it still errors with:
"An attempt was made to evaluate a closure for [Filament\Forms\Components\Select], but [$values] was unresolvable."
I think the var name should be
$state or something...?