Column.type

Note:

The content in this help topic pertains to SuiteScript 2.0.

Property Description

The return type of the formula used to create the query result column.

This property is set during the execution of Query.createColumn(options) or Component.createColumn(options). If a formula is specified when these methods are called, this property contains the return type of the formula. If a formula is not specified, this property is null.

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 theFormulaType = myFormulaColumn.type;
...
// Add additional code

Syntax

Related Topics