How to display the rows of a db filtered with getItems()

Ask the community
,
1

I have a repeater on my page that is connected with a dataset, but I only wanna show from the row 28 to row 100 from my database connected with dataset. So I tried to use the getItems() function but this is not working.

Here is my code:

$w.onReady(function () {
 
 $w("#dynamicDataset").getItems(28, 72) 
.then( (result) => {
let items = result.items;
$w("#dynamicDataset").save();
console.log(items);
})

...continue...

});

Ps: my repeater is called #listRepeater and looks like:

1920×1080 282 KB

Really need help! Tnks a lot since now!

2

I think you will have to use a normal DATASET…(not sure in this case)
And another thing is, you perhaps have forgot to use → 

$w("#myDataset").onReady(()=>{ })

$w.onReady(function () {
   $w("#myDataset").onReady(()=>{
      $w("#normalDataset").getItems(28, 72) 
      .then( (result) => {
         let items = result.items;
         $w("#dynamicDataset").save();
         console.log(items);
      });
   });
});
3

Hey tnxs for your answer. I implemented your tips but still doesn’t work :sleepy:

4

@bellecampos
Ok, show me an example of your DB-structure and few rows of values.
Did you use a normal DATASET, which is also connected to your DB ?
Did you also SYNCED your PREVIEW-DB with LIVE-DB ?
Did you also setted up DB-PERMISSIONS right?
Did you settep-up the READ/WRITE option in your DATASET, the right way?

Check all these tips. :wink: