Column.type

Property Description

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

This property is set during the 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 Searches 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