Hi,
I have a 'attachment' type variable in my record producer which i have made mandatory. When the user uploads any attachment, i want the attachment to get saved in the record created. But instead, it is hiding it.
I can see the entry created in sys_attachment but under table name field, a prefix ZZ_YY is getting added which is making the attachment hidden.
Please find the field below -
Record in sys_attachment -
Can anyone help me get this attachment added in the record as it happens when add any attachment from here -
This worked well for me
1) I created Async After Insert BR on the target table
2) Script as this
a) Remove the ZZ_YY
b) Then use the Copy Attachment
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var gr = new GlideRecord("sys_attachment");
gr.addQuery("table_name", "ZZ_YY" + current.getTableName());
gr.addQuery("table_sys_id", current.sys_id);
gr.query();
if (gr.next()) {
gr.table_name = current.getTableName();
gr.update();
new global.VariableUtil().copy(gr.sys_id, current.getTableName(), current.sys_id);
}
})(current, previous);Output:
1) The file added to the record
2) The file present on the attachment variable
Regards
Ankur
Hi,
So the BR is in global scope
Does your table has Can Create checkbox as true in Application Access and Accessible from All application scopes
Regards
Ankur
