After 24 hours I finally worked out the answer to this!! There you go:
import wixData from 'wix-data';
$w.onReady(function () {
wixData.query("yourdatabase")
.isNotEmpty("keyofthecolumnthatcanbeempty")
.find()
.then((results) => {
$w("#yourrepeater").data = results.items;
});
});
To find the key of the column, click on your database, then click on the name of the column, then “Properties”. You will find Field Key, that’s the one you need to use! ![]()