Search and filter multiple data per user selection

Ask the community
1

hello there,

i know i have been requesting this for a while but unfortunately i am not getting any assistant :frowning:
anyway
this is the new test and it give me an error !

export function Search_click(event, $w) {
 // searching based on user selection, if not selected then check other input
       wixData.query('Property').contains('propertyCat', $w('#iCat').value)
        .or(wixData.query('Property').contains('propertyFunction', $w('#iFunction').value))
        .or(wixData.query('Property').contains('propertyType', $w('#iType').value))
        .or(wixData.query('Property').contains('price', $w('#iPrice').value))
        .and(wixData.query('Property').eq('avaliability', true))
            .find()
            .then(
                 (results) =>
                            {
 let query = results.query;
                                $w('#repeater1').data = query;
                            }
                )
            .catch((error) => {
 let erMsg = error.message;
 let code = error.code; 

            })

}

what it should do is, a user have multiple drop-down selectors, he/she is prompted to select and filter as per his selection (so its like or function … this or that)

so hope to get some help ! :slight_smile:

2

are you just wanting the user to be able to search a database via a few different dropdown boxes ?

3

at the moment yes , but the user can select which drop box he want and upon it the filter should filter database. the user can select only one drop box or multiple

4

@3shtar Conditional Filtering for Dropdowns on Wix | Corvid Tutorial - YouTube

5

@mikemoynihan99 thank you for sharing the video, but it is totally different than what i am looking for !
i am filtering data that is connected to repeater, were repeater shows the data as per drop down selection
there is a search / filter video provided by wix, but it does not work with me !!