How to search in multiple fields in v3 SelectFilter?
I am using the following relationship select filter:
When I enter a search query in the select filter it should not only find results with a match on "name_en" but also on "shortname_en".
What I tried:
- Add an array of searchable columns to ->searchable(['name_en','shortname_en']) as it would work in the form select => Did not work
- Use a virtual column => Did not work properly because there is not always a value in shortname_en (its nullable) so the virtual is empty in this case
- Using a custom attribute on the model => Didn't work as Filters are doing a direct sql query
Anybody has an idea how to make the Filter search also search in "shortname_en"?
When I enter a search query in the select filter it should not only find results with a match on "name_en" but also on "shortname_en".
What I tried:
- Add an array of searchable columns to ->searchable(['name_en','shortname_en']) as it would work in the form select => Did not work
- Use a virtual column => Did not work properly because there is not always a value in shortname_en (its nullable) so the virtual is empty in this case
- Using a custom attribute on the model => Didn't work as Filters are doing a direct sql query
Anybody has an idea how to make the Filter search also search in "shortname_en"?
