Glide Record From Approval Group to Task

PHOTO EMBED

Tue Mar 26 2024 10:32:19 GMT+0000 (Coordinated Universal Time)

Saved by @Yous

var current_sys_id = "664f26d4TEST_SYSIDf412d3fa"
var grSG = new GlideRecord('sysapproval_group');
if (grSG.get(current_sys_id)) {
    gs.info("============== SYSAPPROVAL GROUP  ===========")
        gs.info('parent: ' + grSG.getDisplayValue('parent'));
        gs.info('assignment_group: ' + grSG.getDisplayValue('assignment_group'));
        gs.info('approval: ' + grSG.getDisplayValue('approval'));
        gs.info('u_reject_cause: ' + grSG.getDisplayValue('u_reject_cause'));
        gs.info('number: ' + grSG.getDisplayValue('number'));
        gs.info('approval_user: ' + grSG.getDisplayValue('approval_user'));
        gs.info('state: ' + grSG.getDisplayValue('state'));
        gs.info('work_notes: ' + grSG.getDisplayValue('work_notes'));

   gs.info("============== SYSAPPROVAL APPROVER ========")
    var grSA = new GlideRecord('sysapproval_approver'); 
        grSA.addQuery('sysapproval', grSG.parent );
		grSA.addQuery('state', "rejected");
		grSA.setLimit(1);
		grSA.query();
		if (grSA.next()) {
            gs.info('approver: ' + grSA.getDisplayValue('approver'));
            gs.info('comments: ' + grSA.getDisplayValue('comments'));
            gs.info('sysapproval: ' + grSA.getDisplayValue('sysapproval'));
            gs.info('state: ' + grSA.getDisplayValue('state'));
            gs.info('group: ' + grSA.getDisplayValue('group'));
            gs.info('wf_activity.name: ' + grSA.getDisplayValue('wf_activity.name'));
        }

    gs.info("============== TASK===============")
    var grScTask = new GlideRecord('sc_task'); 
        grScTask.addQuery('request_item', grSA.sysapproval );
        grScTask.addQuery('u_task_type=tsk3');
        grScTask.setLimit(1);
		grScTask.query();
        if (grScTask.next()) {
            gs.info('assignment_group: ' + grScTask.getDisplayValue('assignment_group'));
            gs.info('u_reject_cause: ' + grScTask.getDisplayValue('u_reject_cause'));
            gs.info('number: ' + grScTask.getDisplayValue('number'));
            gs.info('state: ' + grScTask.getDisplayValue('state'));
            gs.info('comments: ' + grScTask.getDisplayValue('comments'));
            gs.info('request_item: ' + grScTask.getDisplayValue('request_item'));
            gs.info('work_notes: ' + grScTask.getDisplayValue('work_notes'));
        }
}
content_copyCOPY