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!!
![](https://static.wixstatic.com/media/a27d24_924f2587543241dcb0bd80ca058f620c~mv2.jpg/v1/fill/w_980,h_372,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/a27d24_924f2587543241dcb0bd80ca058f620c~mv2.jpg)
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