Modules

filter

 

Objects/Functions

module (N/search)

SuiteScript 2.0

search.Column

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

N/search Module
search.Column
Object Description: Encapsulates a single search column in a search.Search. Use the methods and properties available to the Column object to get or set Column properties. You create a search column object with search.createColumn(options) and add it to a search.Search object that you create with search.create(options) or load with search.load(options). You can pass a Column object as a parameter to the Result.getValue(column) or Result.getText(column) methods. In addition, search.ResultSet contains an array of Column objects returned in the results of a search. For a complete list of this object’s methods and properties, see Column Object Members.
Supported Script Types: All script types For more information, see SuiteScript 2.0 Script Types.
Module: N/search Module
Since: 2015.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=search.Column

Example:

// Code Example 1
//Add additional code
//...
search.create({
type: search.Type.TRANSACTION,
columns: [
'trandate',
'amount',
'entity',
'entity.firstname',
'entity.email',
search.createColumn({
name: 'formulatext',
formula: "{lastname}||', '||{firstname}"
})
],

// When the search is executed, the corresponding column in the result will then contain a value in the form: Last Name, First Name
//...
//Add additional code

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