Searching by case insensitive json columns in global search
Hello,
A colleague of me is having an issue where he isn't able to use the global search to find records which have data stored in JSON columns when the value contains capital letters. For example, the search query
Serving
or serving
has no results, while erving
would return the desired record.
I've tried to look into this by overwriting the global search query. Here I've managed to fetch the term being searched (not sure if there's a better way :D), but passing the $term value of putting hardcoded 'serving' doesn't result in the record being found either:
The string we're searching in the example contains - Serving assets from S3
inside the JSON column.
What could be a solution here?
Thanks in advance!2 Replies
You should do this in
getGlobalSearchResults()
Thanks I'll check tonight π
Thanks that did it! Managed to solve it with the following now.. Forwarded it to my colleague. π (replaced the actual model name with the base one here)