Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

Condition.formula

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

N/query Module
Condition.formula
Property Description: The formula used to create the condition. This property is set during the execution of Query.createCondition(options) and Component.createCondition(options). For more information on formulas, see Formulas in Search and SQL Expressions. This property is not applicable to parent conditions created with the execution of Query.and(conditions), Query.or(conditions), or Query.not(condition).
Type: string (read-only)
Module: N/query Module
Parent Object: query.Condition
Sibling Object Members: Condition Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Condition.formula

Example:

// Code Example 1
// Add additional code
//...
var myTransactionQuery = query.create({
type: query.Type.TRANSACTION
});

var myFormulaCondition = myTransactionQuery.createCondition({
formula: '{amount} * 125',
operator: query.Operator.GREATER,
values: 50000,
type: query.ReturnType.CURRENCY
});

var theFormula = myFormulaCondition.formula;
//...
// Add additional code

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