Calculate and populate a field on story form based on scrum tasks

[Rose17]

Hi all,

The requirement is- I have a field named as 'Efforts' on story form.

I want to calculate the sum of actual hours of all scrum tasks for a story record and populate the calculated value in 'Efforts' field.

For eg- if i have 3 scrum tasks- A,B,C for a story record-'test' having actual hours as 2,4,6. I want to calculate the sum of actual hours of all three scrum tasks(A+B+C i.e 2+4+6=12) and populate calculated value(12) in 'Efforts' field of story- test.

Could someone help me to achieve this?

Thanks in advance

[Ankur Bawiskar]

Hi,

yes

(function executeRule(current, previous /*null when async*/) {

    // Add your code here
    var hours = 0;
    var gr = new GlideRecord("rm_scrum_task");
    gr.addQuery("story", current.story);
    gr.query();
    while(gr.next()) {
        hours = hours + gr.hours;
    }

    var storyRec = current.story.getRefRecord();
    storyRec.effort = parseInt(hours);
    storyRec.update();    

})(current, previous);

Regards
Ankur

[Rose17]

still decimal value is populating.

[Ankur Bawiskar]

Hi,

what is the field type for effort on story table?

Regards
Ankur

[Rose17]

string field.

[Ankur Bawiskar]

then it should work.

Can you share the exact script?