workbook.createSortByMeasure(options)

Method Description

Creates a sort based on a measure.

Returns

workbook.SortByMeasure

Supported Script Types

Server scripts

For more information, see SuiteScript 2.x Script Types.

Governance

None

Module

N/workbook Module

Sibling Module Members

N/workbook Module Members

Since

2021.2

Parameters

Note:

The options parameter is a JavaScript object.

Parameter

Type

Required / Optional

Description

options.measure

workbook.Measure

required

The measure to sort by.

options.otherAxisSelector

Array< workbook.DescendantorSelfNodesSelector | workbook.DimensionSelector | workbook.PathSelector>

required

The selector for the other axis.

options.selector

Array< workbook.DescendantorSelfNodesSelector | workbook.DimensionSelector | workbook.PathSelector>

required

The selector for the sort.

options.sort

workbook.Sort

required

The sort used to create.

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/workbook Module Script Samples. Also see Full scripts in the Tutorial: Creating a Workbook Using the Workbook API topic.

            // Add additional code
...
var mySortByMeasure = workbook.createSortByMeasure({
    measure: myWorkbookMeasure,    // previously created workbook.Measure object
    otherAxisSelector: myAxisSelector,  // previously created workbook.DescendantorSelfNodesSelector, workbook.DimensionSelector, or workbook.PathSelector object
    selector: mySelector,           // previously created workbook.DescendantorSelfNodesSelector, workbook.DimensionSelector, or workbook.PathSelector object

    sort: mySort                   // previously created workbook.Sort object    
});
...
// Add additional code 

          

Related Topics

General Notices