Spoiler Spoiler Warning ▲▼
/**
* @NApiVersion 2.x
* @NScriptType ScheduledScript
* @NModuleScope SameAccount
*/
define(["N/search","N/file"],
function(search, file) {
/**
* Definition of the Scheduled script trigger point.
*
* @param {Object} scriptContext
* @param {string} scriptContext.type - The context in which the script is executed. It is one of the values from the scriptContext.InvocationType enum.
* @Since 2015.2
*/
function execute(scriptContext) {
var csvString = '';
var counter = 0;
var searchEmployees = search.load({
id: 133
});
var empResultSet = searchEmployees.run();
empResultSet.each(function(result){
var empInternalId = result.getValue({
name: 'internalid'
});
var ownerSearch = search.create({
type: "script",
filters: [
["owner","anyof",empInternalId]
], columns:
[
search.createColumn({
name: "name",
sort: search.Sort.ASC,
label: "Name"
}),
search.createColumn({name: "scriptid", label: "Script ID"}),
search.createColumn({name: "scripttype", label: "Script Type"}),
search.createColumn({name: "owner", label: "Owner"}),
search.createColumn({name: "isinactive", label: "Inactive"})
]
});
if(counter == 0){
for(var i = 0; i < ownerSearch.columns.length;i++){
log.debug(ownerSearch.columns[i].name);
if(i != ownerSearch.columns.length-1){
csvString += ownerSearch.columns[i].label + ","
} else {
csvString += ownerSearch.columns[i].label + '\n';
}
}
counter++;
}
ownerSearch.run().each(function(ownerResult){
for(var i=0; i < ownerSearch.columns.length;i++){
log.debug(ownerSearch.columns[i].name);
var searchResult = ownerResult.getText({
name: ownerSearch.columns[i].name
});
log.debug("Search Result",searchResult)
if (searchResult == null){
var searchResult = ownerResult.getValue({
name: ownerSearch.columns[i].name
});
}
if(i != ownerSearch.columns.length-1){
csvString += searchResult + ',';
} else {
csvString += searchResult + '\n';
}
}
log.debug(csvString);
});
return true;
});
var date = new Date().toJSON();
var csvFile = file.create({
name: 'search_invalid_owner'+date+'.csv',
fileType: file.Type.CSV,
contents: csvString,
folder: '1255' // Folder ID where the file should be saved in the File Cabinet
});
var csvFileID = csvFile.save();
}
return {
execute: execute
};
});