Script is copying multiple times

[akin9]

Hello Experts,

We want to copy attachments from "sysapproval_approver" table to change request table.

i have created below GlideSysAttachment.copy code is working fine.

but issue is whenever record is inserted or updated copying all attachments every time.

Requirement1.If approver attachment should copy only one time.

Please support me on this

Table =sysapproval_approver

After insert or update BR.

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

// Add your code here

var chg = new GlideRecord('change_request');
if(chg.get(current.sysapproval)){
var attachment = new GlideSysAttachment();
attachment.copy("sysapproval_approver",current.sys_id,"change_request",chg.sys_id);
}

})(current, previous

[SanjivMeher]

If you want to copy the attachment only on insert, It should be an after Insert BR.

If you want to copy attachment, when the approval is approved, you should have an after Update BR, with condition state changed to Approved.

[akin9]

Hello @SanjivMeher 

Thanks for the quick reply!

Issue

1.If  approver attached attachment its pasting on the CR table.

 and whenever i added a comment all the time same attachment is attaching .

Its "like comment - attachment - repeat"

[SanjivMeher]

May be because you dont have a condition in the Business Rule. 

It should only copy when the state changes to Approved.

[akin9]

Hello @SanjivMeher ,

copy when the state changes to Approved is working 

but after insert is not working?

Is it possible to achieve copy and paste attachment only one time?

whether its open state?

please help on this.thanks!