1 ACCEPTED SOLUTION
Hi @Ana39 ,
replace sc_task with child table and sc_req_item with parent table
You can create before update business rule on sc_task table ,
(function executeRule(current, previous /*null when async*/ ) {
// Add your code here
var gr = new GlideRecord('sc_req_item');
gr.addQuery('sys_id', current.getValue('request_item'));
gr.query();
while (gr.next()) {
// gr.work_notes =current.state;
gr.work_notes.setJournalEntry(current.getDisplayValue('state'));
gr.update();
}
})(current, previous);
Updated code:
(function executeRule(current, previous /*null when async*/ ) {
// Add your code here
var gr = new GlideRecord('sc_req_item');
gr.addQuery('sys_id', current.getValue('request_item'));
gr.query();
while (gr.next()) {
// gr.work_notes =current.state;
gr.work_notes.setJournalEntry("SC task "+current.number+" state has been changed to "+"'"+current.getDisplayValue('state')+"'");
gr.update();
}
})(current, previous);
Result: In Ritm Table
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
Hi @Ana39 To do this you would need to create a After Update BR on child table with
condition: State Changes AND
Worknote Changes
and then below script
Script:
var workNotes = current.work_notes.getJournalEntry(1); // get latest worknotes
var comm= new GlideRecord('parentTableName');
comm.addQuery('sys_id', current.parent);// ensure there is a field on your child table which holds Parent reference record
comm.query();
if(comm.next()){
comm.work_notes = "workNotes Updated " +workNotes;// map the worknotes to parent field
comm.update();
}
