Let's say we have a textfield with tags inside. For example we have one row with the value of "menu, navbar, commerce".
Now when the user searches for menu or navbar or commerce or all of them or just two of them. How can we use query setFilter on dataset to accomplish this?
The function hasSome seem like a good choice but it seem that the collection field tag can only contain one word not three comma separated words.
The function hasAll seem like it can search for all cvalues in a field but it still seem to only work when you have one word in the field.
So please, how can the user write "menu navbar" in a textbox and I filter in fields which contains...
Row 1: "menu"
Row 2: "navbar"
Row 3 "menu, navbar"
Row 4: "navbar, menu"
Row 5: "commerce"
All first four records needs to be found and not the fifth, ideas?