Hi Alex,
We are using 2 Business Rules to do something similar - on the sc_task and sc_req_item tables when work notes changes or comments changes.
This is the first BR running on the sc_task table. You'll need something similar to get from sc_task to sc_req_item, then add sc_req_item to sc_request. This has an extra check to make sure they don't keep updating each other recursively.
(function executeRule(current, previous /*null when async*/) {
var ritm = new GlideRecord('sc_req_item');
if(ritm.get(current.request_item.sys_id)){
var curWN = current.work_notes.getJournalEntry(1);
var curTN = current.number;
var curAG = current.assignment_group.name;
var curAC = current.comments.getJournalEntry(1);
if(ritm.work_notes.getJournalEntry(1) == '' || curWN.indexOf(ritm.work_notes.getJournalEntry(1)) <0){
var newWN = curTN + " - assigned to " + curAG + "\n\n" + curWN;
ritm.work_notes = newWN;
var newAC = curTN + " - assigned to " + curAG + "\n\n" + curAC;
ritm.comments = newAC;
ritm.update();
}
}
})(current, previous);
Then the similar script running in a BR on the sc_req_item table to update every one of its sc_task records.
(function executeRule(current, previous /*null when async*/) {
var sctask = new GlideRecord('sc_task');
sctask.addQuery('request_item', current.sys_id);
sctask.addQuery('active', 'true');
sctask.query();
while(sctask.next()){
var curWN = current.work_notes.getJournalEntry(1);
var curTN = current.number;
var curAG = current.assignment_group.name;
var curAC = current.comments.getJournalEntry(1);
if(sctask.work_notes.getJournalEntry(1) == '' || curWN.indexOf(sctask.work_notes.getJournalEntry(1)) <0){
var newWN = curTN + " - assigned to " + curAG + "\n\n" + curWN;
sctask.work_notes = newWN;
var newAC = curTN + " - assigned to " + curAG + "\n\n" + curAC;
sctask.comments = newAC;
sctask.update();
}
}
})(current, previous);
