How to get the search result in Suitescript 1.0 with join

 var inventorybalanceSearch = nlapiSearchRecord("inventorybalance",null,
     [
         ["item.type","anyof","Assembly"],
         "AND",
         ["binnumber","anyof","8521"],
         
     ],
     [
         new nlobjSearchColumn("item",null,"GROUP").setSort(false),
         new nlobjSearchColumn("name","inventoryStatus","GROUP"),
         new nlobjSearchColumn("inventorynumber","inventoryNumber","GROUP")
     ]
 );

 var result = inventorybalanceSearch[0];
 var columns = result.getAllColumns();
 var columnLen = columns.length;
 nlapiLogExecution('DEBUG','result', result)

 nlapiLogExecution('DEBUG','columnLen', columnLen)


 for (i = 0; i <= columnLen; i++)
 {
     var column = columns[i];
     var value = result.getValue(column);
     resultArray.push(value)
     // nlapiLogExecution('DEBUG', 'resultArray', resultArray);
     // nlapiLogExecution('DEBUG', 'inventoryStatus', resultArray[1]);
 }

var inventoryStatus = resultArray[1]
nlapiLogExecution('DEBUG', 'inventoryStatus', inventoryStatus);

return inventoryStatus

Leave a comment

Your email address will not be published. Required fields are marked *