Jacob D
06/18/2025, 11:03 PMnSearch.createColumn({
name: 'formulanumeric1',
summary: 'MIN',
formula: 'CASE WHEN {memberitem.inventorylocation} = {memberitem.preferredlocation} THEN NVL({memberitem.locationquantityavailable}, 0) END'
})
michoel
07/03/2025, 4:16 AM/**
* Run a search and retrieve search results as a plain JSON object (keyed by column label)
*
* @param {import("N/search").Search} savedSearch A Saved Search object
* @returns {{ [key: string]: string | boolean | string[] }[]} All results from the saved search,
* as object keyed by column label
*/
function getAllSearchResults(savedSearch) {
const results = [];
const pagedData = savedSearch.runPaged({ pageSize: 1000 });
pagedData.pageRanges.forEach((pageRange) => {
const currentPage = pagedData.fetch({ index: pageRange.index });
currentPage.data.forEach((result) => {
const resultObject = {};
result.columns.forEach((column) => {
resultObject[column.label] = result.getText(column) || result.getValue(column);
});
results.push(resultObject);
});
});
return results;
}