Hi, I have watched the video “How to create a search for your database” I have created my database, the dropdown works fine but I can not get the search input to work. Please what is wrong with my code below? (see attached screen shots)
Thank you
import wixData from “wix-data”;
$w.onReady(() => {
loadActivity();
});
let lastFilterTitle;
let lastFilterName;
let debounceTimer;
export function iTitle_keyPress(event, $w) {
if (debounceTimer) {
clearTimeout(debounceTimer);
debounceTimer = undefined;
}
debounceTimer = setTimeout(() => {
filter($w(‘#iTitle’).value, lastFilterName);
}, 500);
}
export function iActivity_change(event, $w) {
filter(lastFilterTitle, $w(‘#iActivity’).value);
}
function filter(title, name) {
if (lastFilterTitle !== title || lastFilterName !== name) {
let newFilter = wixData.filter();
if (title)
newFilter = newFilter.contains(‘locationTitle’, title);
if (name)
newFilter = newFilter.contains(‘name’, name);
$w(‘#dataset1’).setFilter(newFilter);
lastFilterTitle = title;
lastFilterName = name;
}
}
function loadActivity() {
wixData.query(‘Activity’)
.find()
.then(res => {
let options = [{“value”: ‘’, “label”: ‘All Activities’}];
options.push(…res.items.map(name => {
return {“value”: name.title, “label”: name.title};
}));
$w(‘#iActivity’).options = options;
});
}
