Site Name : Lifestyledesign
Domain : zankabba.com (Site Unpublished)
Page : New Page [Attached the image]
Dear Wix Team, I am a contributor of this site & I uplaoded a country & city database with entries around 3,000,000. When I am try to filter the cities according to country it shows an error. I tried to query and push results to a dropdown., but that also shows errors. Please help on this matter. Thanks. Sahan.
Code I tried:
export function button2_click(event) {
//Add your code for this event here:
let country = $w( ‘#dropdown1’ ).value;
let city = $w( ‘#input3’ ).value;
$w( "#dataset3" ).setFilter( wixData.filter()
.eq( "country" , country)
.contains( "city" , city)
)
wixData.query( "Cities" )
.eq( “country” ,country)
.contains( “city” ,city)
.ascending( “city” )
.limit ( 100 )
.find()
.then( (results) => {
let items = results.items;
console.log(items)
let items1 = results.items[ 0 ];
console.log(items1)
let resultLength = results.length;
console.log(resultLength)
// var i;
// for ( i = 0 ; i < resultLength; i++) {
// let itemi = results.items[i];
// console.log(itemi)
// let opts = $w(“#dropdown2”).options;
// opts.push({ label: itemi , value: itemi })
// $w(“#dropdown2”).options = opts;
// }
});
}
