Worknotes should be updated to catalog task when it is updated on RITM

[shivani39]

Hi All,

Can we copy worknotes in the task when it is updated in RITM of a catalog.

I have tried the below Business rule, looks like after and async is not working and when trying with Before, I am getting an error "Before Business Rules should not modify records on other tables".

I have kept the filter to run this BR on one specific catalog only with update/insert option.

(function executeRule(current, previous /*null when new*/ ) {
//if (current.cat_item.sys_id == '9690844b1b0e7f406380777b1d4bcb28') {
var tasks = new GlideRecord('sc_task');
tasks.addQuery('request_item', current.sys_id);
tasks.query();
while (tasks.next()) {
gs.info('update worknotes');
tasks.work_notes = current.work_notes;
tasks.update();
}
// }
})(current, previous);

[Sandeep Rajput]

@shivani39 Please check if there is any existing BR on SC Task table which is copying the worknote from Task to RITM.

[Ravi Gaurav]

// Run the Business Rule when the work notes field is updated
if (current.work_notes.changes()) {

// Get the task record associated with the RITM
var taskGR = new GlideRecord('task');
taskGR.addQuery('request_item', current.sys_id);
taskGR.query();

// Update the work notes field on the associated task record
while (taskGR.next()) {
taskGR.work_notes = current.work_notes.getJournalEntry(-1);
taskGR.update();
}
}

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.