Drop-down list database search

Ask the community
,
1

I’m attempting to create a database search with more than one drop-down list. The drop-down lists do not depend on each other, and I need the user to also have the ability to choose 1 or more filters, not necessarily all of them. The results will be displayed using a repeater linked to the dataset. Can anyone give me a hand with the coding I have tried to use below? I’m at a dead end!!

1097×416 45 KB

import {wixData} from ‘wix-data’;

export function SearchButton_click(event, $w) {
$w(“#dataset1”).setFilter(wixData.filter()

.contains(“country”, $w(“#CountryDropdown”).value)(“sex”, $w(“#SexDropdown”).value) (“preferredPosition”, $w(“#PositionDropdown”).value)(“highestLevelPlayed”, $w(“#HighestLevelDropdown”).value)(“availablity”, $w(“#AvailabilityDropdown”).value)
);

$w(“#repeater1”).expand();
}

Any help would be greatly appreciated. Thanks