Can I have some assistance here I am having an issue filtering dataset when it get put into database by and custom input page I have created in a page. If I enter information to the database manual the filtering works perfect.
This is driving me crazy as what could be the issue bellow is some pictures and my code
I have attached a picture of my input page
Here is a picture of my display page with the table and filtering aspects (upon load it shows an entry that I did by filling out the form and submitting it to database.
Here is a picture of the filtering working but for some reason that entry still displays but doesn’t get filtered.
Here is a picture of the Locations database that the information is on
And the following is the code used one the table page for the filtering to happen and the table to get populated by the class type checkmarks.
// For full API documentation, including code examples, visit Velo API Reference - Wix.com
$w.onReady( function () {
//TODO: write your page related code here…
});
import wixData from ‘wix-data’;
function ClassFilter() {
wixData.query("Locations")
.eq("basic", $w("#checkbox1").checked)
.or(
wixData.query("Locations")
.eq("advance", $w("#checkbox2").checked)
)
.or(
wixData.query("Locations")
.eq("junior", $w("#checkbox3").checked)
)
.or(
wixData.query("Locations")
.eq("extreme", $w("#checkbox4").checked)
)
.or(
wixData.query("Locations")
.eq("toning", $w("#checkbox5").checked)
)
// add or statements for the other checkboxes
.find()
.then(res => {
console.log(res.items);
let Classes = res.items;
$w('#table1').rows = Classes;
})
. **catch** ((err) => {
let errorMsg = err;
console.log(errorMsg);
});
}
$w.onReady( function () {
ClassFilter();
});
export function checkbox1_change(event) {
ClassFilter();
}
export function checkbox2_change(event) {
ClassFilter();
}
export function checkbox3_change(event) {
ClassFilter();
}
export function checkbox4_change(event) {
ClassFilter();
}
export function checkbox5_change(event) {
ClassFilter();
}