I have the following document structure:
root(object) items(object) item(array) item[index](object) itemname(string) itenmprice(string)
I’m looking for a way to search inside of the item object for names and prices based on partial matches and return the item object back, text search isn’t supported for the needed locale so i am left with regex i think.
i’ve created a collation index for itemname and tried using regex and string values for find but i can’t seem to make it work with the input i provide.
also what’s the difference between locale and locale@collation=search?