Make the Attachment variable used in the catalog item add the file to the top of case as when using the paper clip

[Gabriel Alowa]

Recently Servicenow added a new variable type named attachment and it works great. Here is my question. When that variable is used on the catalog item , it attaches the file in the work note in the case created. That location is different from where the files is attached when using the paper clip . Is here a way to make the new variable attachment add the file to the top of the case as when you use the paper clip? 

[Peter Williams]

i have two attachment buttons on my form but this code will only work for one of them while the other attachment shows still as ZZ_YY

[Brad Bowman]

It sounds like you have two records that meet the GlideRecord criteria, so try changing the 

	if (gr.next()) {

 to 

	while (gr.next()) {

or else look at the attachment table to see how the record that isn't getting changed differs, then add that as a second GlideRecord query.  Also see the update that the copy function in the referenced Script Include has been renamed to copyAttachment.

[Peter Williams]

i tried that and it causing the attachment to double meaning if i have 2 attachemtns from the two buttons it will be 4 attachment. duplicates

[Peter Williams]

but i think i found the solution for it

here is my updated code

(function executeRule(current, previous /*null when async*/) {
// Add your code here
var attachmentIDs = [];

var gr = new GlideRecord("sys_attachment");
gr.addQuery("table_name", "ZZ_YY" + current.getTableName());
gr.addQuery("table_sys_id", current.sys_id);
gr.query();

// Collect the attachment sys_ids
while (gr.next()) {
attachmentIDs.push(gr.sys_id.toString());
}

// Copy attachments using the collected sys_ids
for (var i = 0; i < attachmentIDs.length; i++) {
var attachment = new GlideRecord("sys_attachment");
if (attachment.get(attachmentIDs[i])) {
new global.VariableUtil().copyAttachment(attachment.sys_id, current.getTableName(), current.sys_id);
}
}
})(current, previous);

[Gabriel Alowa]

As you can see below I follow instruction from the scrip but it is getting attached only in the ZZ_YY table_name. What Am I missing ?  should I change the table name in the scripts?

Thank you