Hi,i am trying to setup a simple database filtering,works fine on text but won't work for numbers
In the console shows that the code was executed but it brings no results.Any idea?suggestion please
screenshot
![](https://static.wixstatic.com/media/a27d24_678548eb89b54130924e3fb37771ce0c~mv2.png/v1/fill/w_980,h_551,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/a27d24_678548eb89b54130924e3fb37771ce0c~mv2.png)
$w.onReady(function () {
});
export function button1_click(event, $w) {
wixData.query("ForSale")
.contains("propertyType", $w('#PropertyTypeDropDown').value) //works
.contains("bathrooms", $w("#dropdown9").value) //returns no results
.find()
.then( (results) => {
console.log("Dataset is now filtered");
$w("#repeater1").data = results.items;
}).catch((err) => {
console.log(err);
});
$w('#repeater1').expand();
}
Thank you I have already brushed through the documentation and tried that as well
.or(wixData.query('ForSale').ge('bathrooms',$w("#dropdown9").value))
do you have any other suggestion?
Thank you
Add a 'or' into your query.
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html#or