Enum Description
Holds the string values for the formula return types supported with the N/query Module.
This enum is used to pass the formula return type argument to Query.createColumn(options), Component.createColumn(options), Query.createCondition(options), and Component.createCondition(options).
For more information about these return types, see Formula Fields.
Module
N/query Module
Sibling Module Members
N/query Module Members
Value
ANY
BOOLEAN
CLOBTEXT
CURRENCY
DATE
DATETIME
DURATION
FLOAT
INTEGER
KEY
PERCENT
RELATIONSHIP
STRING
UNKNOWN
// Add additional code
…
var myTransactionQuery = query.create({
type: query.Type.TRANSACTION
});
var myFormulaColumn = myTransactionQuery.createColumn({
type: query.ReturnType.CURRENCY,
formula: ‘{amount} * 125’
});
…
// Add additional code