function updateAgingCategoryField() {
var elapsedTime = 0;
var aging = '';
var currentTimeNow = gs.nowDateTime();
var gr = new GlideRecord('incident');
gr.addEncodedQuery('u_incident_age!=>120^ORu_incident_age=');
gr.query();
while(gr.next()) {
elapsedTime = (gs.dateDiff(gr.opened_at, currentTimeNow, true)) /60/60/24;
//check to see when the item was created
if (elapsedTime <= 30) aging = 'below 30';
if (elapsedTime > 30) aging = 'above 30';
if (elapsedTime > 60) aging = 'above 60';
if (elapsedTime > 90) aging = 'above 90';
gr.setWorkflow(false);
gr.autoSysFields(false);
gr.u_incident_age = aging;
gr.update();
}
}
Hello,
I have a requirement that show incident age using scheduled jobs and the field im using is choice field and the choices are "Below 30 days", "Above 30 days", "Above 60 days", "Above 90 days". My code wont working please help what i've missed.
