I’m creating checkbox filters based on boolean values. I’ve figured out how to filter for multiple boolean values using the ‘or’ function (e.g. showing all products that are organic OR vegan) but want to create it so that whatever values are selected are treated as ‘and’ functions (e.g. showing all products that are organic AND vegan). I’ve tried switching all the ‘or’ functions to ‘and’ functions, but that will only show content when all three values are selected. How do I make it so that only the values selected will populate as ‘and’ functions.
import wixData from 'wix-data';
function fillRepeater() {
let mealFilter = wixData.query("Meal")
.eq("organic", $w("#checkbox1").checked)
.or(
wixData.query("Meal")
.eq("vegan", $w("#checkbox2").checked)
)
.or(
wixData.query("Meal")
.eq("lowFat", $w("#checkbox3").checked)
)
mealFilter.find()
.then((results) => {
let companies = results.items;
$w('#repeater1').data = companies; // fills the repeater
})
.catch((err) => {
let errorMsg = err;
console.log(errorMsg);
});
}
$w.onReady(function () {
fillRepeater();
// Set the information to the repeater
$w('#repeater1').onItemReady(($w, itemData) => {
// Add here all the relevant elements of the repeater
$w('#text9').text = itemData.name;
$w('#text10').text = itemData.mealTypes;
});
});
export function button1_click(event) {
//Add your code for this event here:
fillRepeater()
}