How to fetch data in batch of 100

Question

rule!PRO_qrtGap( isActive: true, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 2000) ) for now i kept batch size 2000 .Pls let me know how to fetch first 500 , den 501 to 1000 etc...

Konduru Chaitanya · Answer

Hello Klaus34 , 
 You need to consider taking two local variables one for your start index and one for your batchSize. Have defaults as 1 and 500 respectively. Now when you want to fetch the next batch, use a richText and provide dynamic link which will update these two variables to 501 and 1000 respectively. 
 I hope this will help.

jamesm4933 · Answer

Given: 
 p = page number - 1 
 w = batch size (or width) 
 Your startIndex will be: p*w+1 
 
 p needs to be 0 based to get the arithmetic to work, which is why you need to subtract 1. 
 Remember to do bounds checking in your buttons, so you don't end up at page number -1, for instance. 
 You will also likely have to make an allowance for the last page. 
 The last page will start at: if(mod(totalCount, w) = 0, totalCount-w+1, totalCount - mod(totalCount, w)+1), and it will return if(mod(totalCount, w) = 0, w, mod(totalCount, w)) entries. 
 
 So, just don't assume that you can index a full page width, unless you have verified that you are NOT on the last page. 
 
 Edit: Had to add the ifs.