mynt

Workbook object method · N/workbook

runPivot()

Workbook.runPivot(options)

Runs a pivot in the workbook and returns the results as a set of row-column intersections.

Implementation
Not started
Design
Open for proposals suggest how it should read
Proposals
A suitescript api
Signature
Workbook.runPivot(options)
Returns
workbook.PivotIntersection []
Governance
10 units for each intersection returned
Script types
Server scripts
Version
SuiteScript 2.x, documented for 2.1; since NetSuite 2021.2
call shapefrom Oracle's parameter table
1objWorkbook.runPivot({2    id: /* string, required */3});
Oracle reference for this method
ParameterTypeRequiredDescription
options.idstringrequiredThe ID of the pivot.
B mynt syntax

No Mynt syntax yet.

Nothing in the language compiles to Workbook.runPivot(options) today. How should it read?

C community proposals

Competing syntax for runPivot, 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/workbook · Workbook.runPivot(options)

Suggest syntax for runPivot