How to move the approval /rejection status to work notes in ritm

[jobin1]

Hi All

In ritm form is some one is approved or rejected the approval then the same message has to be updated in work notes as well, How we can achieve this?

[Ankur Bawiskar]

@jobin 

Since you want the comments to be moved only during rejection; you add this condition in your after update BR

current.source_table == 'sc_req_item' && current.state == 'rejected' && current.comments.changes()

Regards
Ankur

[shloke04]

Hi,

Write a Before Update Business Rule on Approval table and use the script below:

Table: sysapproval_approver

Before Update

Condition: Comments Changes

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

	// Add your code here
	var gr = new GlideRecord('sc_req_item');
	gr.addQuery('sys_id',current.sysapproval);
	gr.query();
	if(gr.next()){
		gr.work_notes = current.comments;
	}

})(current, previous);

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Below code is tested. Use this ins an After Update BR:

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

	// Add your code here
	var gr = new GlideRecord('change_request');
	gr.addQuery('sys_id',current.document_id);
	gr.query();
	if(gr.next()){
		gr.work_notes = current.comments.getJournalEntry(1);
		gr.update();
	}

})(current, previous);

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

@jobin 

Attching the screenshot of the BR as well and Result:

Code to be used:

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

	// Add your code here
	var gr = new GlideRecord('sc_req_item');
	gr.addQuery('sys_id',current.sysapproval);
	gr.query();
	if(gr.next()){
		gr.work_notes = current.comments.getJournalEntry(1);
		gr.update();
	}

})(current, previous);

BR:

Result:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Let me know if you are facing an issue. Since Comments is a Journal field you need to use "getJournalEntry(1)" to get the last update comments and copy it to the RITM work notes.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke