I understand there is limitation of 5000 records r...
# suitescriptm
Munish Singla
09/14/2020, 5:07 AMI understand there is limitation of 5000 records return by suitescript. But is there any way by some logic I can return all records?
n
nzy
09/14/2020, 5:59 AM Copy code
function getAllSearchResult(searchObject) {
var pages = searchObject.runPaged({
pageSize: 1000
}); //5
var result = [];
for (var i = 0; i < pages.pageRanges.length; i++) {
//log.debug(i, scriptObj.getRemainingUsage() + ', ' + new Date());
var singlePage = pages.fetch({
index: i
}); //5
//log.debug(i, scriptObj.getRemainingUsage() + ', ' + new Date());
for (var j = 0; j < singlePage.data.length; j += 1) {
result.push(singlePage.data[j]);
}
}
return result;
}nzy
09/14/2020, 5:59 AMi dont repeat myself except reusing this piece of code.
nzy
09/14/2020, 6:00 AMbut do have your eyes on the getRemainingUsage()
m
Munish Singla
09/14/2020, 7:50 AMand can you give example what did you pass in searchObject?
Munish Singla
09/14/2020, 8:05 AMhow can I dynamically pass the object to above function?
b
battk
09/14/2020, 8:12 AMyou really want to gain an understanding of the technologies used be these scripts
battk
09/14/2020, 8:18 AMa non suitescript alternative is Connect, which are likely sql views
6 Views