Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

SuiteQL.columns

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=SuiteQL.columns for more information.

N/query Module
SuiteQL.columns
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. 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
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=SuiteQL.columns

Example:

// Code Example 1
// Add additional code
//...
// myQuery is an existing query.Query object
var mySuiteQLQuery = myQuery.toSuiteQL();

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

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_157960405619.html