Glide Record From Approval Group to Task
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')); } }
Comments