Can you add a screenshot of the top part of the Business Rule itself? I just want to make sure it is indeed active AND running on the Incident table.
Also, it looks like you've completely changed the structure of the code itself (which is why it's not running I believe). The default code should look something like this:
(function executeRule(current, previous /*null when async*/) {
// Add your code here
})(current, previous);
So your code should look something like this:
(function executeRule(current, previous /*null when async*/ ) {
gs.info("JC - Finally running!!!");
var total = 0;
var gr = new GlideRecord('task_time_worked'); //related list table name
gr.addQuery("task", current.getValue('sys_id'));
gr.query();
while (gr.next()) {
total += gr.time_worked.dateNumericValue();
}
current.u_total_time_worked.setDateNumericValue(total);
})(current, previous);
I changed your query so that it's looking at the "task" field and not "incident". So if we got the BR working (and I think it finally will), you would have ended up calculating time worked for ALL Tasks!!!!! And is the field name you want to update called "u_total_time_worked" or "total_time_worked" without the "u_" prefix?
