question Re: Copy Attachment in App Engine forum

Copy Attachment

NAIDILE S — Mon, 25 Nov 2024 13:21:07 GMT

Hi,

I have a table where i want to copy the attachment to Security incident from Security request.

In Security request we have a UI action called " convert to security incident" once it is converted Security incident will be created and the attachment to be copied over.

I tried using After -insert BR. but its not working . ANywhere im goin wrong? can anyone suggest on this

Here is the code which i tried

var sourceTable = "sn_si_request";

var targetTable = "sn_si_incident";

var attachment = new GlideSysAttachment();

attachment.copy(sourceTable,current.sys_id, targetTable,current.sys_id);

Re: Copy Attachment

Runjay Patel — Mon, 25 Nov 2024 13:43:45 GMT

Hi @NAIDILE S ,

In UI Action you can try below code.

var grIncident = new GlideRecord('sn_si_incident'); // Table name for Security Incident grIncident.initialize(); grIncident.short_description = current.short_description; grIncident.description = current.description; grIncident.insert(); // Copy attachments var attachment = new GlideSysAttachment(); attachment.copy('security_request', current.sys_id, 'sn_si_incident', grIncident.sys_id);

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

Re: Copy Attachment

Brad Bowman — Mon, 25 Nov 2024 14:09:07 GMT

Since your Business Rule is running on the sn_si_incident table, 'current.sys_id' will be the sys_id of the incident record, so it is correct to use it as the 4th parameter in the copy method. The second parameter needs to be the sys_id of the request record. Luckily, when the UI Action is used, the parent field on the incident is populated with a reference to the request, so you can use

attachment.copy(sourceTable, current.parent, targetTable, current.sys_id);

I wouldn't recommend altering the out of box UI Action as you will miss out on any updates that are made to the script or condition in future releases. You especially don't want to add code that creates another incident when the out of box script already does that nicely, linking the two records, assigning the incident, and displaying an ifo message with the link to the new incident.

Re: Copy Attachment

Juhi Poddar — Mon, 25 Nov 2024 13:56:20 GMT

Hello @NAIDILE S

There is no need to create separate BR as this will run even when new record is inserted without click of UI button.
Try to copy the attachment when record is created.

Please refer to the script below:

// Ensure this script is added to the "Convert to Security Incident" UI Action // Create the Security Incident record var incidentGr = new GlideRecord("sn_si_incident"); incidentGr.initialize(); incidentGr.short_description = current.short_description; // Copy fields as needed incidentGr.description = current.description; incidentGr.some_field = current.some_field; // Copy other fields if needed incidentGr.insert(); // Insert the new Security Incident record // Copy attachments from the Security Request to the new Security Incident var attachment = new GlideSysAttachment(); try { attachment.copy("sn_si_request", current.sys_id, "sn_si_incident", incidentGr.sys_id); gs.addInfoMessage("Attachments copied successfully to the new Security Incident."); } catch (e) { gs.addErrorMessage("Error copying attachments: " + e.message); } // Redirect to the new Security Incident (optional) action.setRedirectURL(incidentGr);

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

Thank You
Juhi Poddar

Re: Copy Attachment

Pooja2998 — Mon, 25 Nov 2024 16:44:04 GMT

Hello @NAIDILE S ,
Please try This After insert Business Rule:

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

if (current.parent) {

var parentSysid = current.parent.toString();

gs.addInfoMessage("Parent sys_id: " + parentSysid);

var attachmentGR = new GlideRecord('sys_attachment');

attachmentGR.addQuery('table_sys_id', parentSysid);

attachmentGR.query();

var attachmentCount = attachmentGR.getRowCount();

gs.addInfoMessage("Number of attachments" + attachmentCount);

if (attachmentCount > 0) {

while (attachmentGR.next()) {

GlideSysAttachment.copy('sn_si_scan_request', parentSysid, 'sn_si_incident', current.sys_id);

}

})(current, previous);

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Pooja.

Re: Copy Attachment

NAIDILE S — Tue, 26 Nov 2024 04:50:25 GMT

Thanks for the solution, using BR it worked for me

Re: Copy Attachment

NAIDILE S — Tue, 26 Nov 2024 04:51:45 GMT

Thanks for the solution,using BR it worked for me

Re: Copy Attachment

Runjay Patel — Tue, 26 Nov 2024 05:04:47 GMT

Hi @NAIDILE S ,

JFI, Writing BR is not the best solution, BR will run on every new insert.

Re: Copy Attachment

NAIDILE S — Tue, 26 Nov 2024 05:21:55 GMT

Hi,
UI action which is present is OOTB and we cannot customize it. so went with the BR

and for every insert of SIR(security incident) from Security Request(from UI action "convert to security incident) a new SIR will be created