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