wsangster
06/27/2022, 7:58 PMvar createSaveSearch = search.create({
type: "customer",
filters:
[
["isinactive","is","F"],
"AND",
["internalid","anyof","11980"]
],
columns:
[
search.createColumn({name: "internalid", label: "Internal ID"}),
search.createColumn({name: "entityid", join: "contact", label: "Name"})
]
})
It's not bringing back the contact names.ehcanadian
06/27/2022, 8:20 PMMarvin
06/27/2022, 11:12 PMwsangster
06/27/2022, 11:37 PM/**
* @NApiVersion 2.x
* @NScriptType UserEventScript
* @NModuleScope SameAccount
*/
define(['N/runtime', 'N/record', 'N/search', 'N/config', 'N/ui/serverWidget' ],
function(runtime, record, search, config, ui)
{
function beforeLoad(context)
{
var form = context.form; //ui.createForm({ title: 'Select Field from Search' });
var formField = form.addField({id: 'custpage_saved_searches',
type: 'select',
label: 'List of contacts',
// container: 'salesorders'
});
var objSavedSearches = getSavedSearches();
log.debug({
title: 'objSavedSearches.length',
details: objSavedSearches.length
});
for (var i = 0; i < objSavedSearches.length; i++) {
if (i == 0)
// formField.addSelectOption({
// value: "",
// text: "",
// });
formField.addSelectOption({
value: objSavedSearches[i].id,
text: objSavedSearches[i].name,
});
}
function getSavedSearches() {
var createSaveSearch = search.create({
type: "customer",
filters:
[
["isinactive","is","F"],
"AND",
["internalid","anyof","11980"]
],
columns:
[
search.createColumn({name: "internalid", label: "Internal ID"}),
search.createColumn({name: "entityid", join: "contact", label: "Name"})
]
})
resultObj = []
var saveSearchResult = createSaveSearch.run()
saveSearchResult.each(function (item) {
obj = {}
obj.id = item.getValue({name: "internalid"})
log.debug({
title: 'obj.id',
details: obj.id
});
obj.name = item.getValue({name: "entityid"})
log.debug({
title: 'obj.name',
details: obj.name
});
resultObj.push(obj)
return true
})
log.debug({
title: 'resultObj',
details: resultObj
});
return resultObj;
}
}
return {
beforeLoad : beforeLoad
};
});
ehcanadian
06/27/2022, 11:41 PMjoin
in your item.getValue({name: 'entityid', join: 'contact'})
wsangster
06/27/2022, 11:41 PMMarvin
06/27/2022, 11:43 PM.getvalue
.wsangster
06/27/2022, 11:54 PM