Copy currently inserted attachment

[Petr Pastuszek1]

Hello Team

When attachment is added to sc task we need to copy it to ritm.

but only currently inserted file/files,not those inserted yesterday and so on

any advice on script in BR on attachment table.

[Siddhesh Wani1]

Hi Petr,

There is one ServiceNow function for the copy attachment you can try this 

'GlideSysAttachment.copy'

https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server_legacy/GlideSysAttachmentGl...

To copy the only 1st attachment you can try with if loop, so it will take only 1st attachment.

If you find the solution useful Please mark this response as correct 

Thanks and regard,

Siddhesh

[Aniket Chavan]

Hello @Petr Pastuszek1 ,

Please give a try to the code below and see how it works for you,

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

    // Get the current task record
    var taskRec = new GlideRecord('sc_task');
    if (taskRec.get(current.table_sys_id)) {

        // Query for the most recent attachment with the current timestamp
        var attachment = new GlideRecord('sys_attachment');
        attachment.addQuery('table_sys_id', current.table_sys_id);
        attachment.orderByDesc('sys_created_on');
        attachment.setLimit(1); // Limit the result set to 1 record
        attachment.query();

        if (attachment.next()) {

            // Get the associated RITM record
            var ritmRec = new GlideRecord('sc_req_item');
            if (ritmRec.get(taskRec.request_item)) {

                // Copy the latest attachment to the RITM
                var gsa = new GlideSysAttachment();
                gsa.writeContentStream(
                    ritmRec,
                    attachment.file_name,
                    attachment.content_type,
                    gsa.getContentStream(attachment.sys_id)
                );
            }
        }
    }

})(current, previous);

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks & Regards,

Aniket.

[Petr Pastuszek1]

Thank you!!!
I will give it try today in few hours,not at pc now.

user can insert 1 or more attachments at one time and those I need to duplicate to rirm always.

when I tried yesterday glidesysattachcopy function from ServiceNow,it always copy attachments uploaded in past whcih is not what we want. Only those files uploaded at current time.

/Petr

/Petr

[Aniket Chavan]

Hello @Petr Pastuszek1 ,

Okay then please give a try to the script below, which will allow you to copy multiple attachments for the current time

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

    // Get the current task record
    var taskRec = new GlideRecord('sc_task');
    if (taskRec.get(current.table_sys_id)) {

        // Query for attachments with the current timestamp
        var attachment = new GlideRecord('sys_attachment');
        attachment.addQuery('table_sys_id', current.table_sys_id);
        attachment.addQuery('sys_created_on', '>=', gs.daysAgo(0)); // Attachments created today
        attachment.orderByDesc('sys_created_on');
        attachment.query();

        // Loop through the attachments
        while (attachment.next()) {

            // Get the associated RITM record
            var ritmRec = new GlideRecord('sc_req_item');
            if (ritmRec.get(taskRec.request_item)) {

                // Copy each attachment to the RITM
                var gsa = new GlideSysAttachment();
                gsa.writeContentStream(
                    ritmRec,
                    attachment.file_name,
                    attachment.content_type,
                    gsa.getContentStream(attachment.sys_id)
                );
            }
        }
    }

})(current, previous);