pen one
05/20/2021, 1:41 PMvar zipcode = recCurrent.getValue({ fieldId: 'custbody217'});
var zonePUcontactSearch = search.create({
type: "customrecord715",
columns: [
search.createColumn({ name: "custrecord440", summary: "MIN", label: "Zone"}),
search.createColumn({name: "custrecord439", summary: "GROUP", label: "Airport Code"})
],
filters : [["custrecord437","is",zipcode ]]
});
var pagedData = zonePUcontactSearch.runPaged({pageSize: 1000});
// iterate the pages
for( var i=0; i < pagedData.pageRanges.length; i++ ) {
// fetch the current page data
var currentPage = pagedData.fetch(i);
// and forEach() thru all results
currentPage.data.forEach( function(result) {
// you have the result row. use it like this....
var zone= result.getValue({"name":"custrecord440","summary":"MIN"});
var airportcode = result.getValue({"name":'custrecord439',"summary":"GROUP"});
console.log("Zone for this zip code is " + zone);
console.log("Airport Code for this zip code is " + airportcode);
});
}
battk
05/20/2021, 1:46 PMbattk
05/20/2021, 1:47 PMpen one
05/20/2021, 2:20 PMpen one
05/20/2021, 2:21 PMbattk
05/20/2021, 2:34 PMbattk
05/20/2021, 2:34 PM