Column.formula

Note:

The content in this help topic pertains to SuiteScript 2.0.

Property Description

A formula used to create the query result column.

This property is set during the execution of Query.createColumn(options) or Component.createColumn(options). This property and the Column.fieldId property cannot be set at the same time.

For more information about formulas, see Formulas in Search and SQL Expressions.

Type

string (read-only)

Module

N/query Module

Parent Object

query.Column

Sibling Object Members

Column 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 myFormulaColumn = myTransactionQuery.createColumn({ type: query.ReturnType.CURRENCY, formula: '{amount} * 125'
}); var theFormula = myFormulaColumn.formula;
...
// Add additional code

Syntax

Related Topics