Copying attachments - not working

[Josh80]

Hi...

I've researched the wiki and I believe I have a Business Rule that should work for my requirement, but it is not.

I've used this Wiki article:

copy attachments from one task to another

To build this - However, it is not working.   Any suggestions?   Thank you!

(Note: We have a custom 'alert' table that was implemented before 'event mgmt' was created.

Alerts are inserted into this table; the NOC then creates Incidents off of these Alerts.

So, on the Alert record there is a custom field 'u_incident' which contains the number of the Incident that is generated from the Alert.

the Alert is in the related list on the only created Incident.)

==============

function onAfter(current, previous) {

var gr = new GlideRecord('u_alert');   //query the customer alert table

gr.addQuery('sys_id', current.u_incident);     //look for the sys_id of the current incident record in the 'u_incident' field on the Alert record

gr.query();

while(gr.next()) {

GlideSysAttachment.copy("incident", current.sys_id, "u_alert", gr.sys_id);     //copy the attachment to the current incident from the alert record that was queried

  gr.update();

}

}

===============

[manikorada]

Josh,

On which table are you writing this business rule?

[Josh80]

Hello Mani

I'm writing it against the Incident table after Incident is inserted

[manikorada]

Josh,

So, you would like to copy the attachments from the incident to the alert? is that right?

If so then the script will be :

var gr = new GlideRecord('u_alert');   //query the customer alert table

gr.addQuery('u_incident', current.sys_id);     //look for the sys_id of the current incident record in the 'u_incident' field on the Alert record

gr.query();

while(gr.next()) {

GlideSysAttachment.copy("incident", current.sys_id, "u_alert", gr.sys_id);     //copy the attachment to the current incident from the alert record that was queried

  gr.update();

}

[Josh80]

Hi Mani -

No, from the alert to the Incident