How to Copy Problem record Work Notes into Related Incident work notes

chanikya · ‎07-17-2018

Hi,

Not working my BR script

After

Condition: current.work_notes.changes()

var updateInitiatedBy = updateInitiatedBy || current.sys_id.toString();
(function executeRule(current, previous /*null when async*/) {

// Add your code here

if(updateInitiatedBy == current.sys_id.toString()){
var gr = new GlideRecord('incident');
gr.addQuery('problem_id',current.sys_id);
gr.query();
while(gr.next()){
gr.work_notes = current.work_notes;
gr.update();
}
}

georgimavrodiev · ‎07-18-2018

Or you can use the same Business Rule as for Incident Work notes -> simply specify a second variable:

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

// This Business Rule ensures that if there is a Parent Problem record, which has one or more Incidents records associated to it as Child Incidents or Problem Task(s) -> then, whenever the Work notes of the Problem get updated -> the Work notes of all Child Incidents & Problem Tasks will be updated accordingly with the same text;

// var rec = Child Incident(s);
var rec = new GlideRecord("incident");
rec.addQuery("problem_id", current.sys_id);
rec.addActiveQuery();
rec.query();
while (rec.next()) {

rec.work_notes = "Incident Work note copied from Parent Problem" + ':' + current.work_notes.getJournalEntry(1); // //Choose a text of your own, which suits you;
rec.update();
}

// var prtask = Child Problem Task(s);
var prtask = new GlideRecord("problem_task");
prtask.addQuery("problem", current.sys_id);
prtask.addActiveQuery();
prtask.query();
while (prtask.next()) {

prtask.work_notes = "Problem Task Work note copied from Parent Problem" + ':' + ' ' + current.work_notes.getJournalEntry(1);
prtask.update(); //Choose a text of your own, which suits you;
}

})(current, previous);

Best Regards,
Georgi Mavrodiev

IT Consultant
Do IT Wise Bulgaria

You may visit us in our Web Site: www.doitwise.com

View solution in original post

JMitchell · ‎07-17-2018

What is the purpose of the updateInitiatedBy variable? I feel that if you include the changes that Mike suggested, but omit that variable, and the if statement, that your script will run as intended.

chanikya · ‎07-17-2018

it is working but here we have small problem.

One PROBLEM record had aroundly 5 incidents then work notes are copied into only One incident record.

So how can we solve it.

Harsh Vardhan · ‎07-18-2018

Script is correct can you validate with your if condition might be possible in if condition its only getting few incident not all 5.

chanikya · ‎07-18-2018

How can we update 5 Incidents work notes ?

Harsh Vardhan · ‎07-18-2018

the above script will update that.. can you please validate with if condition.