Zack
09/18/2018, 6:02 PMerictgrubaugh
09/18/2018, 6:23 PMrequire(["N/search"], function (s) {
// Formula for calculating the difference (in Days) between the Date
// and the Date Created, rounded up with CEIL
var daysElapsedFormula = "CEIL({date}-{datecreated})";
var lateEntriesSearch = s.create({
type: s.Type.TIME_BILL,
filters: [
["formulanumeric: " + daysElapsedFormula, s.Operator.GREATERTHAN, 7]
],
columns: [
"employee",
"date",
"datecreated",
{
name: "formulanumeric",
formula: daysElapsedFormula
},
{
name: "formulanumeric",
formula: "{date}-{datecreated}"
}
]
});
console.log("# Late Entries = " + lateEntriesSearch.runPaged().count);
var results = lateEntriesSearch.run().getRange({start: 0, end: 1000});
var lateEntries = results.map(resultToObject);
console.table(lateEntries);
function resultToObject(result) {
var res = result.toJSON();
console.log(res);
return {
employeeName: result.getText({name: "employee"}),
daysElapsed: res.values.formulanumeric,
daysElapsedNoRound: res.values.formulanumeric_1
};
}
});erictgrubaugh
09/18/2018, 6:24 PMtoJSON method, then you can access the columns by name through the values propertyerictgrubaugh
09/18/2018, 6:24 PMeminero
09/18/2018, 11:11 PM