pen one
06/03/2021, 2:12 AMvar salesorder= recCurrent.getValue({fieldId: 'id'});
var s = search.create({
type: "salesorder",
filters:
[
["type","anyof","SalesOrd"],
"AND",
["mainline","is","T"],
"AND",
["internalid","anyof",salesorder]
],
columns:
[
search.createColumn({
name: "custrecord_license_number",
join: "CUSTRECORD230",
summary: "GROUP",
})
]
});
var pagedData = s.runPaged({pageSize: 1000});
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
var currentPage = pagedData.fetch(i);
currentPage.data.forEach( function(result) {
var licenseNumbers = result.getValue({ name: "custrecord_license_number", join: "CUSTRECORD230", summary: "GROUP"});
console.log("License Numbers are " + licenseNumbers)
recCurrent.setValue({ fieldId: 'custbody_all_license_numbers', value: licenseNumbers});
});
}