Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.ExpressionType

{workbook}.ExpressionType{AND: {and},ANY_IN_HIERARCHY: {anyInHierarchy},ANY_OF: {anyOf},BETWEEN: {between},CHILD_OF: {childOf},COMPARE: ${7:compare},CONSOLIDATE: ${8:simpleConsolidate},CURRENCY_CONVERSION: ${9:currencyConversion},DATE_RANGE_SELECTOR_ID: {0:dateRangeSelectorId},DATE_SELECTOR_ID: {1:dateSelectorId},DATE_TIME_PROPERTY: {2:dateTimeProperty},EQUALS: {3:equals},FIELD: {4:field},HIERARCHY: {5:hierarchy},HIERARCHY_TO_TEXT: {6:hierarchyToText},IN_RANGE: {7:inRange},IS_NULL: {8:isNull},LAMBDA: {9:lambdaArgument},NOT: {0:not},OR: {1:or},RECORD_DISPLAY_VALUE: {2:recordDisplayValue},RECORD_KEY: {3:recordKey},TRUNCATE_DATE_TIME: {4:truncateDateTime}})

N/workbook Module
workbook.ExpressionType
Enum Description: Holds string values for expression types. Use these values for the options.functionId parameter when creating an expression using workbook.createExpression(options). Each expression type uses a set of parameters, which you specify using the options.parameters parameter of workbook.createExpression(options). Make sure that you use the exact parameter names that are supported for each expression type. For example, if you create an EQUALS expression, the supported parameters are a and b. You can specify these parameters as the value of the options.parameters parameter of workbook.createExpression(options): Expressions are used in the following methods: workbook.createChartDefinition(options) workbook.createDataDimensionItem(options) workbook.createMeasure(options) workbook.createConditionalFilter(options)
Module: N/workbook Module
Sibling Module Members: N/workbook Module Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.ExpressionType

Example:

// Code Example 1
parameters: {
a: ,
b:
}

// Code Example 2
// Add additional code
//...
var myExpression = workbook.createExpression({
functionId: workbook.ExpressionType.EQUALS,
parameters: {
a: dataset.getExpressionFromColumn({
alias: 'salary'
}),
b: workbook.createConstant(10000)
}
});
// Add additional code

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