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!
Getting a subset of records error
function extract_all_messages(input){ var accum = new Array(); var last = 0; var filters = new Array(); var columns=new Array(); var end=100; // sensible starting value if(input['start'] != ''){ last=input['start']; } if(input['end'] != ''){ end=input['end']; } do{ columns[0]=new nlobjSearchColumn('message', 'messages'); columns[1]=new nlobjSearchColumn('author', 'messages'); columns[2]=new nlobjSearchColumn('messagedate', 'messages'); filters[0] = new nlobjSearchFilter('internalid', null, 'greaterthanorequalto', last); filters[1] = new nlobjSearchFilter('internalid', null, 'lessthanorequalto', end); var tmp = nlapiSearchRecord('supportcase', 'customsearch_get_total_cases', filters, columns); if(tmp){ last = tmp[tmp.length -1].getId(); accum = accum.concat(tmp); } }while(tmp && tmp.length == 1000); return accum; } I have the above code to extract all messages from tickets, and it was working quite well, until recently. I had 'internalidnumber', and I tried with 'internalid', not sure why I'm getting the following.
0