Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to expand on maximum of 1000 records in suitelet
HI,
I have a suitelet here that I have written that leverages a saved search to query data from Netsuite.
I have recently discovered that if there are 1000 records returned from the saved search, I cant return any more of these via my suitelet.
Is this possible ? How does one go about getting the total number of records so that i can know how many records are actually in existence ?
Thanks in advance
function transactionSearch(request,response) { try { //var custId = '2737'; var custId = request.getParameter('custId'); var type = request.getParameter('type'); //'SalesOrd'; var searchId = request.getParameter('searchId'); // the internal ID of the search within Netsuite var lastId = '0'; var isBack = ''; var retObj = []; var filter = []; filter.push(new nlobjSearchFilter('internalid','customer','anyOf',custId)); var columns = [ new nlobjSearchColumn('internalid').setSort(true) ]; if (isBack) { columns[0] .setSort(false); filter.push(new nlobjSearchFilter('internalidnumber', null, 'lessthan', lastId)); } var rs = nlapiSearchRecord('transaction',searchId ,filter); // add in a saved search for transactions here. response.write(JSON.stringify(rs)); } catch(e) { response.write('[{"result" : "no records found" }]'); } } 0