Search Feature for Database

Ask the community
,
6

import wixData from ‘wix-data’;

export function button1_click(event, $w) {
//Add your code for this event here:
wixData.query(‘Applications’)
.contains(‘name’, $w(‘#searchbox’).value)
.or(wixData.query(‘Applications’)
.contains(‘position’, $w(‘#searchbox’).value))
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
});
}
So to anyone else having this issue, this is what the solution looks like:

.or(wixData.query(‘Applications’)
.contains(‘position’, $w(‘#searchbox’).value))

Duplicate these two lines as many times as needed to cover all of your fields, while changing ‘position’ to each particular field name as you go.