Wix search from multiple databases

Ask the community
1

I’m working on a big project that has more than 20 databases. What I’m trying to do for my client is to build a search bar that pulls information from all those 20 databases plus wix blog database and then display results on a repeater. I’m aware how to make a search function for a single database but not for multiple ones. Any tips will be welcome!

P.S. I don’t want to use the third party widgets for search functionality.

2

https://www.wix.com/corvid/forum/community-discussion/multiple-database-connection

That’s the answer :slight_smile:

3

Thanks for your reply but I went through this article it still doesn’t solve my issue. I’m aware of how to reference databases but when I do then my problem is the following.

  1. I have 10 databases that store all the information I need for my dynamic pages. For example Beaches, villages, monasteries, acropolis etc plus the wix blog database. I want to search from all those databases just the title and description with a “contain” statement and then if I get a match to show on a single repeater the Title, image and short description from that specific row.

2)My issue here is that I can manage to get the code to search on each database but I cannot manage to get it to display the information on a single repeater because even when I use a single database called search that has all the reference from the other databases then I cannot attach the referenced fields on the repeater to show the specific information.

Thank you in advance

4

You’ll probably have to use Corvid for this, and if you want it to be efficient at all you’ll have to employ some backend functions. Data hooks that create a new entry in your search database with only some data to be displayed in your search repeater could be a decent option.

5

Thank you SKMedia…I’ve spend a week now trying to develop a search bar that pulls information from all databases that are manually created and also the default wix blog database. Believe it or not I managed to achieve multiple database search functionality that displays the information to a single repeater just with wix corvid coding. My only issue at the moment is that for some reason I cannot pull any data from wix blog as well. Are you interested to help me out with my code in return of having it as well in case you need it in the future?

6

@webolut I’m afraid Wix blog has some heavy duty restrictions in terms of the database, not just for data hooks, but also for queries. If you’d like you can email me directly and find a solution.