Ichimoku
05/08/2020, 10:32 PMborncorp
05/08/2020, 11:30 PMIchimoku
05/08/2020, 11:31 PMcreece
05/09/2020, 12:05 AMbattk
05/09/2020, 12:41 AMfunction nlapiLookupField(type, id, columns, text) {
nsapiCheckArgs(
[type, id, columns],
["type", "id", "columns"],
"nlapiLookupField"
);
nsapiCheckType(type, "nlapiLookupField");
var searchcolumns = new Array();
if (isArray(columns)) {
for (var i = 0; i < columns.length; i++) {
var column = columns[i];
if (column.toLowerCase() != "recordtype") {
var name =
column.indexOf(".") != -1
? column.substring(column.indexOf(".") + 1)
: column;
var join =
column.indexOf(".") != -1
? column.substring(0, column.indexOf("."))
: null;
searchcolumns[searchcolumns.length] = new nlobjSearchColumn(name, join);
}
}
} else if (columns.toLowerCase() != "recordtype") {
var name =
columns.indexOf(".") != -1
? columns.substring(columns.indexOf(".") + 1)
: columns;
var join =
columns.indexOf(".") != -1
? columns.substring(0, columns.indexOf("."))
: null;
searchcolumns[0] = new nlobjSearchColumn(name, join);
}
var result = nlapiSearchRecord(
type,
null,
new nlobjSearchFilter("internalid", null, "anyof", id),
searchcolumns
);
var results = null;
if (result != null && result.length > 0) {
results = new Object();
if (isArray(columns)) {
for (var i = 0; i < columns.length; i++) {
var name =
columns[i].indexOf(".") != -1
? columns[i].substring(columns[i].indexOf(".") + 1)
: columns[i];
var join =
columns[i].indexOf(".") != -1
? columns[i].substring(0, columns[i].indexOf("."))
: null;
results[columns[i]] =
name.toLowerCase() == "recordtype"
? result[0].getRecordType()
: text
? result[0].getText(name, join)
: result[0].getValue(name, join);
}
} else {
var name =
columns.indexOf(".") != -1
? columns.substring(columns.indexOf(".") + 1)
: columns;
var join =
columns.indexOf(".") != -1
? columns.substring(0, columns.indexOf("."))
: null;
results =
name.toLowerCase() == "recordtype"
? result[0].getRecordType()
: text
? result[0].getText(name, join)
: result[0].getValue(name, join);
}
}
return results;
}
Patrick A.
05/09/2020, 1:48 AMborncorp
05/09/2020, 8:15 AMbattk
05/09/2020, 8:34 AMbattk
05/09/2020, 8:34 AMbattk
05/09/2020, 8:35 AM