mynt

SuiteQL object method · N/query

run()

SuiteQL.run()

Runs the SuiteQL query and returns the query results.

Implementation
Not started
Design
Open for proposals suggest how it should read
Proposals
A suitescript api
Signature
SuiteQL.run()
Module
N/query
Returns
query.ResultSet
Governance
10 units
Script types
Client and server scripts
Version
SuiteScript 2.x, documented for 2.1; since NetSuite 2020.1
call shapefrom Oracle's parameter table
1objSuiteQL.run({2    customScriptId: /* string, optional */3});
Oracle reference for this method
ParameterTypeRequiredDescription
options.customScriptIdstringoptionalA unique identifier used for potential performance issues in a query. If your query produces performance issues, the custom script ID identifies where the update will need to occur. This ID can also be used as a precaution to speed up performance fixes, if necessary. Note: The Script ID must be unique or the performance enhancements will affect each query with the same customScriptID.
B mynt syntax

No Mynt syntax yet.

Nothing in the language compiles to SuiteQL.run() today. How should it read?

C community proposals

Competing syntax for run, from GitHub Discussions. Select two or more to compare them side by side.

All discussions

Loading proposals from GitHub…

D suggest an alternative

Write the Mynt you wish you could write.

A good proposal shows the syntax, the SuiteScript it should become, and argues for it: why it is clearer, how it fits the rest of the language, what it makes harder.

  • Clarity. Does it say what happens, without ceremony?
  • Consistency. Does it read like load, save and Ref[field]?
  • Expressiveness. Does it cover the cases people actually write?
  • Honesty. Does it hide a NetSuite cost, such as governance, that a reader should see?

N/query · SuiteQL.run()

Suggest syntax for run