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 about formulas, see Formulas in Searches and SQL Expressions.

Note:

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

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/query Module Script Samples.

            // 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

Syntax

Related Topics