Using the .or and await features in a wix data query for a search feature.

Ask the community
,
1

Hello,

I have written some code for a search feature on my website. The idea is that the user’s input is saved as a parameter and then the code queries a specific collection and checks specific columns in my dataset for whether they contain this information.

**async function**  searchData ( parameter ) { 
**let**  queryPostsq  =  wixData . query ( 'Questionslist' ) 
**let**  queryPosts  =  queryPostsq . contains ( 'title' ,  parameter ) 
**await**  queryPosts . or ( queryPostsq . contains ( 'description1' ,  parameter )) 
**await**  queryPosts . or ( queryPostsq . contains ( 'topic' ,  parameter )) 
**await**  queryPosts . or ( queryPostsq . contains ( 'question1' ,  parameter ))

My idea was that the code could check the ‘title,’ the ‘description1’ , ‘topic’ and ‘question1’ for each item, and if in any of those text cells the words of the user’s input (parameter) were contained, then it would record that as queryPosts. The code then populates that data into a repeater. The problem I am encountering is that the code only checks the information in the first let queryPosts , and doesn’t appear to check the other columns for the same parameter (the orders following await). I’m not sure if it is a problem with how I am using the .or, or the contains(), or something entirely else.

Thank you in advance!

James