can someone please help me???
i kind of stupid in coding and i trying to create a mix types database search.
everything is working except from the number input (for price value).
if i using text or dropdown it cant do the math because of different values (from 3,000 - 5,500,000).
please i asking here for couple of time with no answer…
this is my search function : (all the price conditions dosent work properly).
export function search () {
let nDataV = wixData.query(‘apartments’);
nDataV.contains('name', $w("#searchBar").value)
.or(nDataV.contains('nighberhood', $w("#searchBar").value))
.and(nDataV.contains('typeSOrR', $w("#typeBar2").value))
.and(nDataV.contains('type', $w("#typeBar").value))
// .between(‘price1’, $w(“#minPrice”).value, $w(“#maxPrice”).value)
// .and(nDataV.ge(‘price1’, $w(“#minPrice”).value))
//.and(nDataV.le(‘price1’, $w(“#maxPrice”).value))
.and(nDataV.ge(‘rooms1’, $w(“#minRooms”).value))
.and(nDataV.le(‘rooms1’, $w(“#maxRooms”).value))
.and(nDataV.ge(‘floor1’, $w(“#minFloor”).value))
.and(nDataV.le(‘floor1’, $w(“#maxFloor”).value))
.find()
.then(res => {
$w('#repeater1').data = res.items
if (res !== null ) {
$w("#repeater1").expand();
}
});
}