Please Help! Delete Specific Records in a Collection?

Ask the community
, ,
5

Not sure, but give this a try…

import wixData from 'wix-data';

$w.onReady(function(){    
    $w('#YourDropdownIDhere').onChange(()=>{
        if ($w("#dropdownName").value) {$w("#btnDelete").enable();}
    }); 

    $w('#myDeleteButtonIDHere').onClick(()=>{DELETE();});   
});

function DELETE() {
    wixData.query("Prospects")
    .eq("email", $w("#dropdownName").value)
    .limit(1000)
    .distinct("_id")
    .then(results => {console.log("ITEMS: ", results.items);
        return wixData.bulkRemove("Prospects", results.items);
    })
    .then((res)=> {console.log("RES: ", res);
        $w("#btnDelete").disable();
        refreshRepeater(results);
    })
    .catch((err) => {console.log(err);
        $w("#txtMessage").text = "An unexpected error has occurred.";
    });
}

function refreshRepeater(DATA) {
    $w('myRepeaterIDhere').data = DATA.items;   
}

To be able to manage your own issue, try to use more the —> CONSOLE.
Take a look, what you get for…

console.log("ITEMS: ", results.items);
console.log("RES: ", res);