workbook.Expression

Object Description

An expression object which can be used when you create a pivot definition, a data dimension item, a measure, a conditional filter, or a constant.

Use workbook.createExpression(options) to create this object.

An expression object is used as a parameter in these methods: workbook.createCalculatedMeasure(options), workbook.createConditionalFilter(options), workbook.createDataDimensionItem(options), workbook.createDataMeasure(options), workbook.createMeasure(options), workbook.createPivot(options), workbook.createReportStyleRule(options), workbook.createTable(options), and workbook.createTableColumn(options).

Supported Script Types

Server scripts

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

Module

N/workbook Module

Methods and Properties

Expression Object Members

Since

2020.2

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 myExpression = workbook.createExpression({
    functionId: workbook.ExpressionType.AND,
    parameters: {
        expressions: [expression1, expression2]
    }
});
...
// Add additional code

Syntax

Related Topics