My company and I are currently building a website on wix, and we've created a page in our website that has a repeater and a search bar. We've watched some videos that show how to connect a repeater to a database, and how to set up a search bar: this is something that we have already completed. We've entered code into our website, and everything works as it should. In our databse collection, each item has a field in which there are a certain number of keywords. Via wix code, we've managed to have it so when you type one of these keywords, the items that have that keyword appear. However, we've noticed that when you type more than one keyword into the search bar nothing appears (unless the item that you are trying to see has those keywords typed in the database in the same way that you entered them into the search bar.
An item in our database has these keywords - Red Blue Yellow. If we type Red Yellow Blue (in this order) into the search bar this item doesn't appear, although the keywords match. We have to type Red Blue Yellow, as it is exactly entered into our database for this item to appear.
We want to know if there is a way to have it so that when you type, say, Red Blue Yellow (in whatever order) into the search bar, all of the items in the database that have one, two, or all of those keywords appear. Moreover, we want to know if there is a way to have the items that appear ranked (the items that have 3 out of the 3 keywords that were entered into the search bar appear first, followed by the items that have 2 out of the 3 keywords that were entered into the search bar second, etc.
We've been in touch with Wix support already, and we were directed to this forum. We've watched many videos showing how to configure data in wix too.
Please help us. If you need me to be more clear about what it is that we are trying to do please let me know.