Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.Expression

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

N/workbook Module
workbook.Expression
Object Description: An expression. An expression can be used when you create a pivot definition, a chart definition, a data dimension item, a measure, a conditional filter, or a constant. You can create an expression using workbook.createExpression(options).
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/workbook Module
Methods and Properties: Expression Object Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.Expression

Example:

// Code Example 1
// Add additional code
//...
// Create a basic Expression
var myExpression = workbook.createExpression({
functionId: query.Operator.EMPTY
});

// Create a complete Expression
var myExpression = workbook.createExpression({
functionId: query.Operator.EQUAL,
parameters: {
parm1: 15
}
});

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

// Note that some Expression properties may be empty/null based on the loaded workbook
var myChartExpression = myWorkbook.chartDefinitions[0].filterExpressions[0];
log.audit({
title: 'ChartDefinition Expression.functionId = ',
details: myChartExpression.functionId
});
log.audit({
title: 'ChartDefinition Expression.parameters = ',
details: myChartExpression.parameters
});

var myPivotExpression = myWorkbook.pivotDefinitions[0].filterExpressions[0];
log.audit({
title: 'PivotDefinition Expression.functionId = ',
details: myPivotExpression.functionId
});
log.audit({
title: 'PivotDefinition Expression.parameters = ',
details: myPivotExpression.parameters
});
//...
// Add additional code

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