Help Populating a Repeater with Query Data

Ask the community
,
1

Hello, I am currently trying to get a repeater to be populated with data from a data sheet, filtered with a query (to eliminate blank items). My first major stumbling block is that I can’t seem to get the data to be accessed on the page at all. This is my current code, I am trying to start out by getting the items in the query data array to show up in the console.
This is my code, currently returning no results or errors:

import wixData from ‘wix-data’;

wixData.query(“dataset1”)
.find()
.then( (results) => {
let items = results.items;
console.log(items);
} ) ;

please help, thanks.

2

try:

import wixData from 'wix-data'; 
let options={suppressAuth:true, suppressHooks:true}

wixData.query("collection1", options)
.find()
.then( (results) => {  
    let items = results.items;
    console.log(items);   
    $w("repeaterZ").data=items;
}) ;
3

thanks for replying! Used that code, still not getting any results. Log is still blank in the preview.

4

I don’t know how to use dataset, but insert you in the code the name of the collection so you can query thee database. Did you do it ?

5

More, did you update ‘Sandbox’ and ‘Live’ collection ?

6

I had to transform the data into float:
https://www.wix.com/corvid/forum/community-discussion/user-number-input-calc-then-output-solved
Mauro Vento Avyno worked for me as is pretty much