
u_updateTaskAging();
function u_updateTaskAging() {
var elapsedTime = 0;
var aging="";
var gr = new GlideRecord('incident');
gr.addEncodedQuery('stateNOT IN7,8');
gr.orderByDesc("sys_created_on");
gr.query();
while (gr.next()) {
var gr1 = new GlideRecord("metric_instance");
gr1.addEncodedQuery("duration!=NULL^value=On Hold^definition=35f2b283c0a808ae000b7132cd0a4f55^id=" + gr.sys_id);
gr1.query();
if (gr1.next()) {
aging="";
elapsedTime = (gs.dateDiff(gr1.start, gr1.end, true)) / 60 / 60 / 24;
if (elapsedTime <= 6) {
aging = '0-6days';
}
if ((elapsedTime > 6) && (elapsedTime <= 30)) {
aging = '7-30days';
}
if (elapsedTime > 30) {
aging = '>30days';
}
gr.setWorkflow(false); // Skip any Business Rules
gr.autoSysFields(false); // Do not update system fields
gr.u_aging_onhold = aging;
gr.update();
}
}
}
How to capture onHold time in incident form ServiceNow
Working Code Asked question August 21, 2024
Sorry, you do not have permission to read comments.