Ok i have looked at tons of vids and instructions but have yet to find a solution to what I know can’t be that hard to do. In the picture provided I have a search box with a clear button to it’s right. I need to be able to search the properties in the database based on date so it will show a list of properties in the table that are due for auction that day. But I also need to set a filter so that it only shows properties that we have mark as interested in the status field of the database. when I apply the filter to the dataset the search code for the date overrides it and shows all properties for the date I searched for. I am assuming that the filter for interested needs to be added to the code used to search by date. I have included the code I am using to search by date. Any help here would be wonderful cause i’m running out of hair and there ain’t that much to begin with. Picture and code are below.
import wixData from ‘wix-data’;
let debounceTimer;
export function input64_keyPress(event) {
if (debounceTimer){
clearTimeout(debounceTimer);
debounceTimer=undefined;
}
debounceTimer=setTimeout(()=>{
filter($w(“#input64”).value);
},200);
}
let lastFilterDateOfAuction
function filter(dateOfAuction) {
if (lastFilterDateOfAuction !== dateOfAuction) {
$w(‘#dataset1’).setFilter(wixData.filter().contains(“dateOfAuction”, dateOfAuction));
lastFilterDateOfAuction=dateOfAuction;
}
}
export function button133_click(event) {
$w(“#dataset1”).refresh()
.then( () => {
console.log(“Done refreshing the dataset”);
} );
$w(‘#input64’).value = false ;
}