@jonatandor35
WDE0058: $gte should be a Date, Number, or String. Got null instead
WDE0058: $lt should be a Date, Number, or String. Got null instead
I’ve got this error message on console… This is my full code
import wixData from ‘wix-data’ ;
export function button12_click ( event ) {
clearImput ()
}
$w . onReady ( function () {
initComps ();
$w ( "#dataset1" ). onReady (() => {
console . log ( 'ready' )
populateFormattedPrice ();
});
$w ( "#dataset1" ). onCurrentIndexChanged (( index ) => {
console . log ( 'index has changed' )
populateNewFormattedPrice ();
});
})
async function initComps () {
// populate iLocation dropdown
const res = await wixData . query ( “TumIlanlar” )
. ascending ( ‘konum’ )
. distinct ( ‘konum’ )
. then (( locationData ) => {
return locationData . items . map (( location ) => {
return {
value : location ,
label : location
}
});
});
$w ( ‘#Konum’ ). options = res ;
}
function populateFormattedPrice () {
$w ( “#dataset1” ). onReady (() => {
$w ( ‘#repeater1’ ). onItemReady (( $item , itemData , index ) => {
const numberWithCommas = (x) => {
return x . toString (). replace ( /\B(?=(\d{3})+(?!\d))/ g , “.” );
}
$item ( ‘#text18’ ). text = “₺” + numberWithCommas ( parseInt ( $item ( ‘#text18’ ). text , 10 ));
});
});
}
function populateNewFormattedPrice () {
$w ( “#dataset1” ). onReady (() => {
$w ( ‘#repeater1’ ). forEachItem (( $newItem , itemData , index ) => {
console . log ( ‘new item ready’ )
const newNumberWithCommas = (x) => {
return x . toString (). replace ( /\B(?=(\d{3})+(?!\d))/ g , “.” );
}
$newItem ( ‘#text18’ ). text = “₺” + newNumberWithCommas ( parseInt ( $newItem ( ‘#text18’ ). text , 10 ));
});
});
}
export function Ara_click ( event , $w ) {
$w ( “#dataset1” ). setFilter ( wixData . filter ()
. eq ( “kategori” , $w ( “#KonutTipi” ). value )
. eq ( “odaSalon” , $w ( “#OdaSalon” ). value )
. eq ( “konum” , $w ( “#Konum” ). value )
. eq ( “lanDurumu” , $w ( “#IlanDurumu” ). value )
. between ( “fiyat” , parseFloat ( $w ( “Minimum” ). value ), parseFloat ( $w ( “Maksimum” ). value )))
. then (( results )=>{
console . log ( “Filtrelendi” );
$w ( “#repeater1” ). data = results . items ;
}). catch (( err ) =>{
console . log ( err );
});
}
//SEARCH_ENGINE()
var DATASET = “#dataset1” // —> Товары // <<<---- put in here your data
var REFERENCE1 = “konum” // —> Этажность // <<<---- put in here your data
var REFERENCE2 = “odaSalon” // —> Дополнительные помещения // <<<---- put in here your data
var REFERENCE3 = “kategori” // —> Спальни // <<<---- put in here your data
var REFERENCE4 = “lanDurumu” // —> Тип кровли // <<<---- put in here your data
var REFERENCE5 = “fiyat” // —> ??? // <<<---- put in here your data
async function SEARCH_ENGINE () {
let item5 = parseFloat ( $w ( “#Minimum” ). value )
let item6 = parseFloat ( $w ( “#Maksimum” ). value )
let filter = wixData . filter ()
let item1 , item2 , item3 , item4
console . log ( $w ( “#Minimum” ). value );
console . log ( $w ( “#Maksimum” ). value );
//DD1-DD5 = DropDowns
let query = wixData . query ( “TumIlanlar” );
if ( item5 & item6 ){ query = query . between ( “fiyat” , item5 , item6 );}
else if ( item5 ){ query = query . ge ( “fiyat” , item5 );}
else if ( item6 ){ query = query . le ( “fiyat” , item6 );}
if ( $w ( “#KonutTipi” ). value ){ query = query . eq ( “kategori” , $w ( “#KonutTipi” ). value );}
if ( $w ( “#OdaSalon” ). value ){ query = query . eq ( “odaSalon” , $w ( “#OdaSalon” ). value );}
if ( $w ( “#Konum” ). value ){ query = query . eq ( “konum” , $w ( “#Konum” ). value );}
if ( $w ( “#IlanDurumu” ). value ){ query = query . eq ( “ilanDurumu” , $w ( “#IlanDurumu” ). value );}
query . find ()
. then ( results => {
$w ( “#repeater1” ). data = results . items ;
});
console . log ( item1 )
console . log ( item2 )
console . log ( item3 )
console . log ( item4 )
if ( item1 != “” ) { filter = filter . eq ( REFERENCE1 , item1 ) }
if ( item2 != “” ) { filter = filter . eq ( REFERENCE2 , item2 ) }
if ( item3 != “” ) { filter = filter . eq ( REFERENCE3 , item3 ) }
if ( item4 != “” ) { filter = filter . eq ( REFERENCE4 , item4 ) }
if ( item5 != 1674 ) { filter = filter . between ( REFERENCE5 , item5 , item6 ) }
console . log ( filter )
await $w ( DATASET ). setFilter ( filter )
// runCounter()
}
function clearImput () {
if (( $w ( “#Minimum” ). value !== null ) || ( $w ( “#Minimum” ). value !== undefined )) {
$w ( "#Minimum" ). value = **null** ;
$w ( "#Minimum" ). resetValidityIndication ();
}
if (( $w ( “#Maksimum” ). value !== null ) || ( $w ( “#Maksimum” ). value !== undefined )) {
$w ( "#Maksimum" ). value = **null** ;
$w ( "#Maksimum" ). resetValidityIndication ();
}
if (( $w ( “#KonutTipi” ). value !== null ) || ( $w ( “#KonutTipi” ). value !== undefined )) {
$w ( "#KonutTipi" ). value = **null** ;
$w ( "#KonutTipi" ). resetValidityIndication ();
}
if (( $w ( “#OdaSalon” ). value !== null ) || ( $w ( “#OdaSalon” ). value !== undefined )) {
$w ( "#OdaSalon" ). value = **null** ;
$w ( "#OdaSalon" ). resetValidityIndication ();
}
if (( $w ( “#Konum” ). value !== null ) || ( $w ( “#Konum” ). value !== undefined )) {
$w ( "#Konum" ). value = **null** ;
$w ( "#Konum" ). resetValidityIndication ();
}
if (( $w ( “#IlanDurumu” ). value !== null ) || ( $w ( “#IlanDurumu” ). value !== undefined )) {
$w ( "#IlanDurumu" ). value = **null** ;
$w ( "#IlanDurumu" ). resetValidityIndication ();
}
}
export function button11_click ( event ) {
// …
$w ( “#dataset1” ). setSort ( wixData . sort ()
. ascending ( “fiyat” )
);
}