SuiteScript search.create Snippet Generator

/**
 * @NApiVersion 2.1
 */
define(['N/search', 'N/log'], (search, log) => {
  const findRecords = () => {
    const s = search.create({
      type: 'salesorder',
      filters: [
        ['status', 'anyof', 'SalesOrd:B']
      ],
      columns: [
        search.createColumn({ name: 'tranid' }),
        search.createColumn({ name: 'entity' }),
        search.createColumn({ name: 'trandate' })
      ]
    });

    const rows = [];
    const paged = s.runPaged({ pageSize: 1000 });
    paged.pageRanges.forEach((range) => {
      const page = paged.fetch({ index: range.index });
      page.data.forEach((result) => {
        rows.push({
          id: result.id,
          tranid: result.getValue({ name: 'tranid' }),
          entity: result.getText({ name: 'entity' }),
          trandate: result.getValue({ name: 'trandate' })
        });
      });
    });

    log.audit('searchDone', rows.length + ' rows');
    return rows;
  };

  return { findRecords: findRecords };
});