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;
  }