Update parent activity log with task state

[Ana39]

Hi there, I am developing a new project in a custom table. I have a child task to the ticket and there is required to add a work note in the parent ticket, every time the child task state changes, 
It is only the task state updates that are required to be added as work notes in the activity log of the parent custom ticket.

Thanks in advance! 

[James Chun]

Hey @Ana39,

You can write a simple Business Rule for it, e.g.

Script:

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

	// Add your code here
	var parentGr = new GlideRecord('sc_req_item');
	parentGr.get(current.getValue('request_item'));
	parentGr.work_notes = 'Some notes here';
	parentGr.update();
	

})(current, previous);

Hope it helps, cheers

[swathisarang98 · 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

[swathisarang98]

@Ana39 did you get a chance to look at my solution ?

Thanks 

Swathi 

[Ana39]

the code ended to be: 

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

    var parentSysId = current.parent;

    var fieldchanges = current.state.getDisplayValue(); // get state

    var grPTPCRequest = new GlideRecord('tablename');

    grPTPCRequest.addQuery('sys_id', parentSysId);

    grPTPCRequest.setLimit(1);

    grPTPCRequest.query();

    if (grPTPCRequest.next()) {

        grPTPCRequest.work_notes = "Update in task #" + current.number + ".  State is now " + fieldchanges;

        grPTPCRequest.update();

    }

})(current, previous);