Trouble with search button for data collection

Ask the community
,
1

I’m having a hard time getting this to work. I followed the article https://support.wix.com/en/article/velo-tutorial-adding-collection-data-search-functionality
but I can’t seem to get it to return results. Here’s my code:

import wixData from ‘wix-data’ ;

export function button1_Click(event) {
wixData.query( ‘PMANewsletterArchive’ )
.contains( ‘keyword’ , $w( ‘#textbox1’ ).value)
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword1’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword2’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword3’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword4’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword5’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword6’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword7’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword8’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword9’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword10’ , $w( ‘#textbox1’ ).value))
.or(wixData.query( ‘PMANewsletterArchive’ ).contains( ‘keyword11’ , $w( ‘#textbox1’ ).value))
.find()
.then((res) => {
$w( ‘#table1’ ).rows =res.items;
$w( “#table1” ).expand();
})
$w.onReady( function () {
$w( ‘#table1’ ).columns = [{
‘id’ : ‘PMANewsletterArchive’ ,
‘dataPath’ : ‘pdf’ ,
‘label’ : ‘pdf’ ,
‘type’ : ‘document’ ,
}];
});
}

The database is “PMANewsletterArchive”. This is on a regular page, not dynamic and the elements are not connected to a dataset per the article (“In this example, the table is not connected to a dataset, so code is needed to set up the table columns to match the data structure.”).

I want the user to input search terms that are in the database under the multiple keyword fields, and return pdf documents that match the search term from the keyword fields. For example if “Baseball” is under Keyword1 it would return the pdf that’s associated with “Baseball” under keyword1. I have multiple keywords because there are multiple pdfs with multiple keywords (some with the same keywords), so I thought this would work. Please help, I’m going a bit nuts!