Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.SortDefinition

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.SortDefinition for more information.

N/workbook Module
workbook.SortDefinition
Object Description: A sort definition. A sort definition can be used with you create a category, a legend, and a pivot axis. You can create a sort definition using workbook.createSortDefinition(options).
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/workbook Module
Methods and Properties: SortDefinition Object Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.SortDefinition

Example:

// Code Example 1
// Add additional code
//...
// Create an AllSubNodesSelector SortDefinition sorted by Measure
var mySortDefinition = workbook.createSortDefinition({
selector: workbook.createAllSubNodesSelector(),
sortBys: [myMeasureSort]
});

// Create a DimensionSelector SortDefinition sorted by Measure
var mySortDefinition = workbook.createSortDefinition({
selector: myDimensionSelector,
sortBys: [myMeasureSort]
});

// Create a PathSelector SortDefinition sorted by Dimension
var mySortDefinition = workbook.createSortDefinition({
selector: myPathSelectorSelector,
sortBys: [myDimensionSort]
});

// View a workbook.SortDefinition used in a ChartDefinition
var myWorkbook = workbook.load ({
id: myWorkbookId
});

var mySortDefinition = myWorkbook.chartDefinitions[0].category.sortDefinitions[0];

// Note that some SortDefinition properties may be empty/null based on the loaded workbook
log.audit({
title: 'SortDefintion.selector = ',
details: mySortDefinition.selector
});
log.audit({
title: 'SortDefinition sortBys = ',
details: mySortDefinition.sortBys
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159008585696.html