(Solved) how can i join two filters for a repeater search?

Ask the community
,
2

Hello petriell0 Anima,

i think you will have to connect your repeater programmatically by corvid to achieve your aim. You are using two differerent search/filtering-functions, which do not communicate/work together.

You should first collect the results in an ARRAY(object) for example, and then pulling these collected results into the repeater.

Something in this direction, where you can for example input a second filter.
Something like that.

import wixData from 'wix-data';

$w.onReady(function () {load_Data()});

export function BTNsearch_click(event) {load_Data()}

function load_Data (parameter) {console.log("GO")
    wixData.query("Companies")
    .contains("column1", $w('#dropdown1').value)
    //inputting a second filter here
    .contains("column2", $w('#dropdown2').value)
    .find()
    .then( (results) => {
 if(results.items.length > 0) {
 let firstItem = results.items[0];

            console.log(results.items)
            $w('#repeater1').data = results.items

            $w("#repeater1").onItemReady( ($item, itemData, index) => {
            $item("#pic").src = itemData.logo;
            $item("#ID").text = itemData.title;
            $item("#group").text = itemData.companyGroup;
            $item("#title").text = itemData.companyName;
 //  $item("#image1").onClick( (event) => {} );
            });
        } 
 else { }
    })
    .catch( (err) => {
 let errorMsg = err;
    });
}