copy attachment from RITM to approval

[akin9]

Hello Experts

We are trying to copy attachments from RITM to sysapproval table.

I have created below BR but unfortunately not working pls correct me,

Table  :sc_req_item

When : After and Insert 

Filter condition : 

Item is "X"

Script : 

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

    function attachApproval() {
        var gr = new GlideRecord('sysapproval_approver');
        gr.addQuery('sys_id', current.sysapproval);
        gr.query();
        while (gr.next()) {
            GlideSysAttachment.copy("sysapproval_approver", gr.sys_id, "sc_req_item", current.sys_id);
        }
    }
})(current, previous);

[akin9]

Hi @Brad Bowman  ,

Thanks for the detailed Explaination.!

I want to achieve this for only two items only.

Item name - "X" and "Y"

[Brad Bowman]

I'm not sure why you wouldn't want to show approval record (parent) attachments for all approvals, but you could make the related list mis-leading by filtering it like this in the relationship query:

(function refineQuery(current, parent) {
	var ritm = new GlideRecord('sc_req_item');
	if (ritm.get(parent.sysapproval)){
		if (ritm.cat_item.name == 'X' || ritm.cat_item.name == 'Y') {
			current.addQuery('table_sys_id', parent.sysapproval);
		} else {
			current.addQuery('sys_id', ''); //no records are displayed
        }
	} else {
		current.addQuery('sys_id', ''); //no records are displayed
    }
})(current, parent);

[Dr Atul G- LNG]

Hi @akin9 

What is the use case for this? To do this, need to write script which is not a best way. We can educate user to use the system and if possible avoid the customization. 

[akin9]

Hello @Dr Atul G- LNG ,

Thanks for the reply!

We have item external user creation. and two level of approvals are there 

If any user related documents attached then approver need to see those attachments.