How to bypass Wix's limit (1000) for conditional dropdown?

Ask the community
,
6

@irvingdesignui
Sorry my fault! I forgot something…

for(var i=0; i<countDB; i++){.......

async function get_bigData() {
   var DB = "MyItems"
   var ColTotal, COLLECTION = []
   var multiplier = 1000
   var countDB = 3

   for (var i=0; i<countDB; i++){
        COLLECTION[i] = await wixData.query(DB)
        .limit(multiplier*i)
        .skip(multiplier*(i-1))
        .find();
   if(i>=countDB) {
            
  ColTotal=COLLECTION[0].items.concat(COLLECTION[1].items).concat(COLLECTION[2].items)
        console.log(ColTotal)
        }
    }
}