WixDataQuery function on array field in database

Ask the community
,
1

Hello,

I’ve built a query on a wix-data collection that has an array field containing keywords. I want to filter my query using WixDataQuery functions to include any item in the database which contains ANY of the inputted search words in the keyword array field.

The following code doesn’t seem to work… if the searchString (inputted search words) doesn’t exactly match one of the keyword strings in the array, the query returns 0 results.

How can I modify the searchString to include ANY of the keywords in the array without matching the string exactly?

wixData.query("Properties")
        .contains("keyword", searchString)
        .eq("jurisdiction", jurisdictionSelection)
        .eq("database", databaseSelection)
        .find()
        .then((results) => {
 if (results.items.length > 0) {
                console.log(results);
            } else {
            }
        }).catch((err) => {
 let errorMsg = err;
        });

Another way of saying this: say a database item has this array in the keywords field:

keywords = ["house", "sunshine", "garage", "three beds", "two bath"]

When a user searches the phrase “two bath house with sunshine”, I want the item to appear in the search results.

Thanks for your help! I feel like the solution is super obvious I just haven’t stumbled across it yet.

Ezra

2

Perhaps you could use this …

Because then you can count your words in the Array —> keywords[0] / keywords[1] …

3

This is cool! Thanks for sharing. I will experiment.

4

No problem.

5

For anyone interested, I found this post by @yoav-wix that shows the full code for what I was hoping to do in terms of searching without exact string phrasing (includes split() as @russian-dima suggested): https://www.wix.com/corvid/forum/community-discussion/search-a-database

Here’s the relevant code:

let query = wixData.query('my-collection')  
    .contains('physicalIssue', searchWords[0]);
    
  for (let i=1; i < searchWords.length; i++) {
    query = query.or(wixData.query('my-collection')
      .contains('physicalIssue', searchWords[i]));