creating multifunction search in the database.

Hi everyone:

         I am new to wix api coding. I have a search function that api code to function as a search engine in my data. but if I want to do a multi field search in my data. such as the table below 


so basically there is a field contain GG AG AA the other field contain 1/1, 1/2, 1/3 and such. when I do a search it could show the result from the table… any one had any idea how could i perform this search ?

the search code that i am using right now is

export function button1_click(event,$w) {
wixData.query(“drugdatabase”).contains(‘name’, $w(‘#input1’).value)
.find()
.then(res =>{
$w(‘#table1’).rows= res.items;

}); 

}

thanks in advance

Hi Lis,

You can use several filters by just chaining them one after the other.
For example,

wixData.query(“drugdatabase”).contains(‘name’, $w(’ #input1 ‘).value).contains(‘other’, $w(’ #input 2’).value)

Hope this helps,

Idan.

thanks !!! i got it !!! thanks alot for the help Idan~!!