I have a column which displays a list of users queried from Firestore. Each user has an "array" of skills stored in Firebase.
It is possible to filter/display users based on skills. E.g.:
Frank's skills are: [cooking, fencing]
John's skills are: [football]
Cindy's skills are: [fencing, boxing]
... and I filter on "fencing", then only the records of Frank and Cindy will be displayed in the column/list.
On the filter skill text field, I did enable "Update Page on Text Change", in order to update the column/list while writing (this is not optimal for performance, but that's how it is...)
I am NOT using "Simple Search" since with simple search you can only filter on single strings (i.e. Simple Search would work if each user only had 1 skill), but not on an array within the same user document.
All this works fine.
My problem is that I would like to have the same behavior when I filter for "Fencing" or "FENCING" or if Cindy had a skill called "quick fencing" and I search for "fencing", she should still appear in the list (which right now will NOT happen, since the array contains function is strict so it will only match "fencing" with "fencing".
Any ideas?