language area · Searches

Ordering and cardinality

order by, limit and first say how many rows a search returns and in which order, so the search fetches no more than that.

Implementation
Implemented published in npm 0.1.0
Kind
Mynt language, not a SuiteScript method
A

Supported · compiles today

mynt
1let customers = search Customer2    where email !== ""3    order by email4    limit 105for customer in customers {6    log.debug(customer.email)7}
suitescriptoutput, trimmed
const customers = mynt$search(search.Type.CUSTOMER, [{ name: "email", sort: "ASC" }], [], [["email", search.Operator.ISNOTEMPTY, ""]], 10);

Searches only: query takes where and nothing else so far. first gives one optional row (see optional values) and reads a single result with getRange.

B

Published on npm since 0.1.0. Verified with mynt build on 13 Oct 2026.

  1. Reached the compiler.
  2. Published in Mynt 0.1.0.
C

SuiteScript methods this feature lowers to or works through. They are counted on their own pages, never through the feature.