N/query Module in NetSuite: SuiteQL Complete Guide

The N/query module lets you run SuiteQL — a SQL-like language — directly in SuiteScript. It is ideal for complex multi-join queries, aggregates, and GROUP BY operations that are impossible with N/search.

Running a SuiteQL Query

define(["N/query", "N/log"], (query, log) => {
  const results = query.runSuiteQL({
    query: "SELECT id, companyname, email FROM customer WHERE isinactive = 'F' ORDER BY companyname"
  });
  results.asMappedResults().forEach((row) => {
    log.debug(row.companyname, row.email);
  });
  return {};
});

Aggregate Example

const results = query.runSuiteQL({
  query: "SELECT entity, SUM(foreigntotal) AS total FROM transaction WHERE recordtype = 'salesorder' GROUP BY entity ORDER BY total DESC FETCH FIRST 10 ROWS ONLY"
});
results.asMappedResults().forEach((r) => log.debug(r.entity, r.total));

Key Methods

Back to All NetSuite Modules