Show More on Randomised Repeater

Ask the community
,
1

I have a repeater within a page that shows the results from my database randomised. There is a button at the bottom of the repeater which I want users to click and show the next 40 cars from that randomised repeater appended onto the bottom of the 40 results currently in the repeater.

I’ve tried using the ‘Load more’ ‘Next page’ and ‘Next item’ options via the connect to data route but with no luck. Instead of appending the next 40 results onto the bottom of the repeater it removes the way the repeater is randomised and instead resets the repeater to show in the sorted A-Z order instead.

Any ideas on what I need to add to append the next 40 randomised items in the repeater?

// Even more cars randomise
wixData.query("Scraper")
    .count()
    .then((num) => {
 let max = num - 3;
 let skip = Math.floor(Math.random() * max) + 1;

        wixData.query("Scraper")
            .ascending("title")
            .skip(skip)
            .limit(40)
            .find()
            .then((results) => {
 let items = results.items;
 // console.log(items); // take a look at what we got
                $w("#repeater1").data = items; // add data to our repeater 
            })
            .catch((error) => {
 let errorMsg = error.message;
 let code = error.code;
            })
    })