Retreive datas using Query

Solution

Instead of using search, we can use query to retrieve data from NetSuite.

Use the ‘N/query’ module.

Simple Example: Retrieving an employee name using the query

define(['N/query','underscore'], function(query,_){
const empName=(internalid)=>
{
const sqlres = query.runSuiteQL({
                query: "SELECT employee.entityid as emName FROM employee WHERE employee.id =?",
                 params: [internalid]
               
            })
  _.each(sqlres.asMappedResults(), (result) => {
 log.debug("NAME",result.emName)
return true;
})
}
});

For more search SuiteQL in SuiteAnswers