Hello my code in business rule returns 'null' or empty value for every field I am trying to get using getValue();. I have a simple app with two tables (Amount_of_points and Sport_list). What I am trying to do is to setup a business rule which is triggered after I make a update/insert on form with Amount_of_points. On a form I will choose a sport to which I will give a certain number of points and I want those points to be counted in the total amount of the specific sport. Attached script does not work and it is not able to sum anything because field 'amount' is always empty for the busines rule script so I am basically sending nothing to me total number of points. Any idea why I am not able to read fields using getValue();? Thank you.
Script:
(function executeRule(current, previous) {
var sportGR = current.sport.getRefRecord();
var amountGR = new GlideRecord('Amount_of_points');
amountGR.addQuery('sport', sportGR.getUniqueValue());
amountGR.query();
//even this part is returning 'null' into my log
gs.info("Amount is " + parseInt(amountGR.getValue('amount'), 10));
while (amountGR.next()) {
sum = sum + parseInt(amountGR.getValue('amount'), 10);
}
sportGR.setValue('progress', sum);
sportGR.update();
})(current, previous);
