Copy Worknotes from RITM to Request

[Samiksha2]

Hi All,

I need to copy RITM work notes for a particular catalog item.

I am not sure what to add in the query.

Please help.

Thanks,

Sam

[Harish KM · Accepted solution]

Hi @Samiksha2 Create a after update BR

cond: item is "your catalog"

script:

var workNotes = current.work_notes.getJournalEntry(1);

var app = new GlideRecord('sc_request');

app.addQuery('sys_id', current.request);

app.query();

if(app.next()){

app.work_notes = "workNotes Updated " +workNotes;

app.update();

}

[Harish KM · Accepted solution]

Hi @Samiksha2 the below cond works for me,

[PPPanchal]

Hello @Samiksha2,

You need to create after business rules on RITM table.

Please refer below screenshots:

(function executeRule(current, previous /*null when async*/) {
	var request = new GlideRecord("sc_request");
	request.addQuery("sys_id", current.request);
	request.query();
	if (request.next()) {
		request.work_notes = current.work_notes.getJournalEntry(1);
		request.update();
		}
})(current, previous);

[Samiksha2]

Thank you everyone for the reply.

But can anyone help me with this query- when worknote is not updated by system then only it should copied.

[Samiksha2]

I guess this will work

grs.addEncodedQuery('sys_updated_by!=system');

Thanks,

Sam

[Samiksha2]

No It is not working