Client Script help!

shane_davis · ‎02-02-2015

I need some help creating a script for the process below. Unfortunately, my limited scripting abilities isn't getting me the required results. Any help is appreciated!

My full process is:

1. I open a Change Task which is assigned to me.

2. I choose my Failure Type and Failure Cause choices which puts an integer in the Failure Score (u_failure_score) field.

All 3 fields are on the change_task table

3. The script should take the Failure Score and add it to the Failed Change Score field (u_failed_change_score) on the User table for the user assigned to the parent Change Request.

In addition, I need to delete the value of u_failed_change_score every 91 days because we only want to keep 90 days history in this field.

Below is code I've tried to create, but it's obviously not all I need...

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

 //Get value of u_failed_change_score on the sys_user table, add that to the u_failure_score on the change_task table, and then overwrite the current user's score with the new score.
 var totalusrscore = g_form.getReference('sys_user');
 // var f2 = g_form.getIntValue('totalusrscore.u_failed_change_score'); //Field on the sys_user table
 var f1 = g_form.getIntValue('u_failure_score'); //Field on the change_task table
 var total = f1 + totalusrscore.u_failed_change_score; //Add the 2 fields together to get the sum

 g_form.setValue('f2', total); //set the score on the sys_user table to the new score
}

kopp820 · ‎02-03-2015

I would create a business rule to run "After" the record has updated. This will only add the current updated score to the existing score on their user record. See the scheduled job below for how to remove anything previous to 90 days.

Here is the script:

(if you're on ServiceNow Eureka, check the Advanced checkbox)

Insert = True

Update = True

When to run = After

Condition: current.u_failure_score.changes()

Script:

var u_usr = new GlideRecord('sys_user'); 


u_usr.addQuery('sys_id',current.change_request.assigned_to); 


u_usr.query(); 


if (u_usr.next()){ 


u_usr.u_failed_change_score += current.u_failure_score; 


u_usr.update(); 


}

Also since you want to remove anything past 90 days old, I believe you should have a daily scheduled job to recalculate the score that runs this script:

var u_usr = new GlideRecord('sys_user');


var u_cTask = new GlideRecord('change_task');


var u_sum = new GlideAggregate('change_task');




//Find all change tasks created in the last 90 days


u_cTask.addEncodedQuery('sys_created_onONLast 90 days@javascript:gs.daysAgoStart(90)@javascript:gs.daysAgoEnd(0)');


u_cTask.query();


while (u_cTask.next()){


var u_at = u_cTask.change_request.assigned_to;





//aggregate the sum of the failure scores grouped by assigned to


u_sum.addAggregate('SUM', 'u_cTask.u_failure_score');


u_sum.groupBy(u_at);


u_sum.query();


while (u_sum.next()){


var total = u_sum.getAggregate('SUM','u_cTask.u_failure_code');





//Here is where you should set that value back to the user record by updating the sys_user table.


//I'm not 100% sure of the code here, but add gs.log statements in the script above to see what


//output you are getting.





//You need something like for each assigned to user, set the u_failed_change_score to be the 


//sum aggregate we got from the above query.

View solution in original post

shane_davis · ‎02-04-2015

Hi Kailey! Thank you for the updated script. The business rule for calculating the score on the user record worked perfectly. Today, I realized that I needed that business rule to run only when our Unsuccessful button is clicked. Then, I need to subtract 1 point when the Successful button is clicked. I am trying to run those off of the conditions below, but the business rules don't seem to be caring about the "action" part. These are the action names of my UI Actions, Successful and Unsuccessful.

current.u_failure_score.changes() && action == 'unsuccessful'

current.u_failure_score.changes() && action == 'successful'

kopp820 · ‎02-04-2015

try current.getActionName() == 'unsuccessful'.

Before putting that in the condition, however, i would add gs.log('action name is ' + current.getActionName()); to see what it's returning. Then check the logs to see if you get the correct name. if you do, then add it to your condition.

shane_davis · ‎02-05-2015

Kailey,

current.getActionName() == 'unsuccessful'

did't work, but

action.getActionName() == 'successful'

worked.

Thank you again! Thanks to you, I'm continuing to make progress toward the final goal.

kopp820 · ‎02-05-2015

nice work! also you may want to think about the case where the score has been updated on the change task. if the score changes on the record, do you want to remove the previous score and add the new one to the user's profile?

shane_davis · ‎02-05-2015

That's a great point. I am sure there will be times when the score needs changed. I'll work on that code. Thank you!