Database Filter Result

Ask the community
,
1

Hi,

I would like to add the filtered result visible to the visitor
Example site:

2796×962 300 KB

I am only able to code the coding for the Result in number ex: Result (109) from the Screenshot above but now i want to add the result same as above,
When visitor check or select the items on the left-side filter, it will show the result tag in the right side.

Mysites:

2796×962 172 KB


$w.onReady(function () {

    //SEARCH BUTTON TRIGGER -SEARCH BAR⚡
    $w("#searchbutton").onClick(function () {
        search();  
    });

    //SEARCH BUTTON TRIGGER -SEARCH BAR⚡
    $w("#ExploreMAT").onClick(function () {
        search();  
    });

    //ENTER KEY TRIGGER⚡
    $w("#searchtittle").onKeyPress(function (event) {
        if (event.key === "Enter") {
            search();
        }
    });

    //SEARCH FUNCTION🚀
    function search() {

        $w("#dataset1").onReady(function () {
            $w("#dataset1").setFilter(wixData.filter().contains('itemPageText', String($w('#brands').value))
                    .and(wixData.filter().contains('materials', String($w('#materialstype').value)))
                    .and(wixData.filter().contains('reinforcements', String($w('#reinforcements').value)))
                    .and(wixData.filter().contains('printingProcess', String($w('#processingtechnology').value)))
                    .and(wixData.filter().contains('materialsForm', String($w('#deliverform').value)))
                    //.and(wixData.filter().contains("certifications", String($w('#certicate').value)))
                    .and(wixData.filter().contains('aviFor', String($w('#availablefor').value)))
                    .and(wixData.filter().contains('polymer', String($w('#polymerfamily').value)))
                    .and(wixData.filter().contains('polymer', String($w('#polymerfamily2').value)))
                    .and(wixData.filter().contains('polymer', String($w('#polymerfamily3').value)))
                    .and(wixData.filter().contains('polymer', String($w('#polymerfamily4').value)))
                    .and(wixData.filter().contains('polymer', String($w('#elastomer').value)))
                    .and(wixData.filter().contains('polymer', String($w('#simulated').value)))
                    .and(wixData.filter().contains('polymer', String($w('#simulated2').value)))
                    .and(wixData.filter().contains('polymer', String($w('#metal').value)))
                    .and(wixData.filter().contains('polymer', String($w('#metal2').value))))
                    //.and(wixData.filter().ge("tensilestrength", Number($w('#tensileSTslider').value))))
                    //.and(wixData.filter().contains("colour_mfg", String($w('#colorfinishing').value))))
                
                .then(count)
                
                $w("#anchor1").scrollTo();
        })
    }

    //COUNT FUNCTION👍
 function count() {
        let count = $w("#dataset1").getTotalCount();
        if (count > 0) {
            $w("#itemsfound").text = `Result (${count})`;
            $w("#SEARCHBARTEXT").text = `(${count}) Results`;
            $w("#ExploreTEXT").text = `Explore (${count}) materials`;

        } else { $w("#itemsfound").text = `No Item Found`; }
               { $w("#SEARCHBARTEXT").text = `(${count}) Results`; }
               { $w("#ExploreTEXT").text = `Explore (${count}) materials`; }

        return count;
    }
2 
import wixData from 'wix-data';

$w.onReady(function() {
    $w("#dataset1").onReady(function() {
        //SEARCH BUTTON TRIGGER -SEARCH BAR⚡
        $w("#searchbutton, ##ExploreMAT").onClick(function () {
            search();  
        });

        //ENTER KEY TRIGGER⚡
        $w("#searchtittle").onKeyPress(function(event) {
            if (event.key === "Enter") {
                search();
            }
        });
    });
});

//SEARCH FUNCTION🚀
function search() {console.log("Search started...");   
    $w("#dataset1").setFilter(wixData.filter().contains('itemPageText', String($w('#brands').value))
        .contains('materials', String($w('#materialstype').value))
        .contains('reinforcements', String($w('#reinforcements').value))
        .contains('printingProcess', String($w('#processingtechnology').value))
        .contains('materialsForm', String($w('#deliverform').value))
        //.and(wixData.filter().contains("certifications", String($w('#certicate').value)))
        .contains('aviFor', String($w('#availablefor').value))
        .contains('polymer', String($w('#polymerfamily').value))
        .contains('polymer', String($w('#polymerfamily2').value))
        .contains('polymer', String($w('#polymerfamily3').value))
        .contains('polymer', String($w('#polymerfamily4').value))
        .contains('polymer', String($w('#elastomer').value))
        //-----------------------
        .and(wixData.filter().contains('polymer', String($w('#simulated').value)))
        .and(wixData.filter().contains('polymer', String($w('#simulated2').value)))
        .and(wixData.filter().contains('polymer', String($w('#metal').value)))
        .and(wixData.filter().contains('polymer', String($w('#metal2').value))))
        //.and(wixData.filter().ge("tensilestrength", Number($w('#tensileSTslider').value))))
        //.and(wixData.filter().contains("colour_mfg", String($w('#colorfinishing').value))))
    .then((res)=>{
        console.log("Results: ", res);
        count(); //<--starting count-function here...
    });
    
    //$w("#anchor1").scrollTo();
}


//COUNT FUNCTION👍
 function count() {
    let count = $w("#dataset1").getTotalCount();
    if (count > 0) {
        $w("#itemsfound").text = `Result (${count})`;
        $w("#SEARCHBARTEXT").text = `(${count}) Results`;
        $w("#ExploreTEXT").text = `Explore (${count}) materials`;

    } 
    else { $w("#itemsfound").text = `No Item Found`;
        $w("#SEARCHBARTEXT").text = `(${count}) Results`;
        $w("#ExploreTEXT").text = `Explore (${count}) materials`;
    }
}

I don’t know if this works (never tested this before).

Looks like your POST (your code) here…

do not open several posts regarding the same issue, especially it is not recommended to bump-up old posts.