Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

Result.asMap()

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=Result.asMap() for more information.

N/query Module
Result.asMap()
Method Description: Returns the query result as a mapped result. A mapped result is a JavaScript object with key-value pairs. In this object, the key is either the field ID or the alias that was used for the corresponding query.Column object.
Returns: Object
Supported Script Types: Client and server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: None
Module: N/query Module
Parent Object: query.Result
Sibling Object Members: Result Object Members
Since: 2019.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Result.asMap()

Example:

// Code Example 1
// Add additional code
//...
var myCustomerQuery = query.create({
type: query.Type.CUSTOMER
});

var mySalesRepJoin = myCustomerQuery.autoJoin({
fieldId: 'salesrep'
});

myCustomerQuery.columns = [
myCustomerQuery.createColumn({
fieldId: 'entityid',
alias: 'cust'
}),
myCustomerQuery.createColumn({
fieldId: 'id'
}),
mySalesRepJoin.createColumn({
fieldId: 'entityid'
}),
mySalesRepJoin.createColumn({
fieldId: 'email'
}),
mySalesRepJoin.createColumn({
fieldId: 'hiredate'
})
];

var resultSet = myCustomerQuery.run();

for (var i = 0; i < resultSet.results.length; i++) {
var mResult = resultSet.results[i].asMap();
log.debug(mResult);
}
//...
// Add additional code

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