Hi all,
I understand that this is probably a small problem, but I am trying to connect my dropdown list to my database (repeater). The search is working perfectly, but I can’t get the dropdown right. Any advice is welcome…
Here is a link to the page: https://www.clewistonchamber.com/membership-directory
Here is my code:
import wixData from “wix-data”;
$w.onReady(() => {
wixData.query(‘Categories’)
.find()
.then(res => {
let options = [{“value”: ‘’, ‘label’: ‘All Categories’}];
options.push(…res.items.map(category => {
return {‘value’: category.title, ‘label’: category.title};
}));
$w(‘#iCategory’).options = options;
})
});
let lastFilterTitle;
let lastFilterCategory;
let debounceTimer;
export function iTitle_keyPress(event, $w) {
if (debounceTimer) {
clearTimeout(debounceTimer);
debounceTimer = undefined;
}
debounceTimer = setTimeout(() => {
filter($w(‘#iTitle’).value, lastFilterCategory);
}, 200);
}
function filter(title, category) {
if (lastFilterTitle !== title || lastFilterCategory !== category) {
let newFilter = wixData.filter();
if (title)
newFilter = newFilter.contains(‘title’, title);
if (category)
newFilter = newFilter.eq(‘category’, category);
$w(‘#dataset1’).setFilter(wixData.filter().contains(‘title’, title));
lastFilterTitle = title;
lastFilterCategory = category
}
}
export function iCategory_change(event, $w) {
filter(lastFilterTitle, $w(‘#iCategory’).value)
}