try {
let salesorderSearchObj = search.create({
type: "salesorder",
filters:
[
["type", "anyof", "SalesOrd"],
"AND",
["linesystemnotes.date", "on", "yesterday"],
"AND",
["linesystemnotes.field", "anyof", "CUSTCOL_DT_STATUS"],
"AND",
["mainline", "is", "F"],
"AND",
["custcol_dt_order", "isnotempty", ""]
],
columns:
[
search.createColumn({
name: "custcol_dt_order",
summary: "GROUP",
label: "DT Order"
}),
search.createColumn({
name: "tranid",
summary: "GROUP",
label: "Document Number"
}),
search.createColumn({
name: "internalid",
summary: "GROUP",
label: "Internal ID"
}),
search.createColumn({
name: "custcol_dt_acct",
summary: "GROUP",
label: "DT Account"
})
]
});
let searchResultCount = salesorderSearchObj.runPaged().count;
if (searchResultCount > 0) {
return salesorderSearchObj;
}
else {
return [];
}
}
catch (e) {
log.error("Error@getInputData", e);
return [];
}
}