SuiteQL.columns

Note:

The content in this help topic pertains to SuiteScript 2.0.

Property Description

The result columns to be returned from the query.

This property is an array of query.Column objects. When you use Query.toSuiteQL() to convert an existing query.Query object to SuiteQL, this property contains the same query.Column objects that were specified for the original query.

Important:

The SuiteQL query string in a query.SuiteQL object (contained in the SuiteQL.query property) does not include any aliases you set on query result columns in the original query.Query object. For more information about aliases, see Column.alias.

Type

query.Column[] (read-only)

Module

N/query Module

Parent Object

query.SuiteQL

Sibling Object Members

SuiteQL Object Members

Since

2020.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
...
// myQuery is an existing query.Query object
var mySuiteQLQuery = myQuery.toSuiteQL();

var theColumns = mySuiteQLQuery.columns;
...
// Add additional code

Syntax

Related Topics