Best way to work with partial text search


I have the following document structure:


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?

Anyone has any ideas?

Please post sample input documents and sample of the expected results.

Coming up with an answer for a question like that implies that we have to have documents in our local mongod instance. Entering documents with the correct schema takes too much time for most of us that are here on our free time.