SuiteQL.columns
|
Property Description |
The result columns to be returned from the query. This property is an 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 |
|
|
Parent Object |
|
|
Sibling Object Members |
|
|
Since |
2020.1 |
Syntax
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