Hi Gabriel,
I'm personally not a fan of the attachment variable type. There may be something more to this that I'm not aware of, but from what I can see I am absolutely shocked that ServiceNow has implemented it this way. First of all, you can only add one file, and it (almost) replicates existing functionality, so what is the point? And putting the attachment in the Work note instead of where it belongs? Wwwhhhyyy? So much confusion. I've used a Macro variable with this simple XML to create an Attachments button that I can order wherever within the variables, and it opens the same dialog window as the the paper clip, so same functionality, no excessive records on the attachments table, and they appear where you expect them to. This method doesn't work in Service Portal since Macro variables are not supported.
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<button class="request_catalog_button_with_icon btn cat-btn btn-primary" onclick='attach()'>Attachments</button>
<script language="javascript">
function attach() {
saveCatAttachment(gel('sysparm_item_guid').value, 'sc_cart_item');
}
</script>
<!-- </td></tr></table> -->
</j:jelly>
The thing I'm most shocked about is that when you attach your one file on the request form then submit the item, you will see in the sys_attachment table that there are now TWO records for the same file - the very thing they preach against the copy attachment utility - they're unnecessarily bloating the database unbeknownst to most. The ZZ_YYsc_cart_item record serves no purpose and should be deleted when the RITM and it's attachment are created, if they're going to do it that way.
If you prefer the look/functionality of the variable over a UI Macro button, a simple before or after Insert Business Rule on the sys_attachment table should put the attachment where it belongs and should have been in the first place, but there seems to be something in place preventing this from working, so there's more than one way to skin this cat. Create an after Insert Business Rule on the sc_req_item table, with no Filter Conditions. Your script will look like this.
(function executeRule(current, previous /*null when async*/) {
var attach = new GlideRecord('sys_attachment');
attach.addQuery('table_name', 'ZZ_YYsc_req_item');
attach.addQuery('table_sys_id', current.sys_id);
attach.query();
while(attach.next()){
attach.table_name = 'sc_req_item';
attach.update();
}
})(current, previous);
