Overview : We are using a record producer to create a new record or update a record on a table based on what criteria the user specifies .
The process works as intended when users are creating new records and upload attachments . New records are created and those attachments are linked correctly .
Issue: We are having an issue with updating records and saving attachments. I've noticed that as soon as you upload an attachment , a table_sys_id is generated in the sys _atttachment table . However since we're updating a record , we already have a sys id that should be used .
I have a script that I have placed in the script section of the record producer. While it works ,its not ideal since it checks for attachments recently uploaded by the user within the past minute and copies that attachment to the desired sys id . In production , users may take a long time to upload attachments and submit the record producer so this wouldn't be the best option .
Does anyone have any better solutions we can use ?
var user = gs.getUserName(); // to get the user's login id
var str = 'sys_created_onONCurrent minute@javascript:gs.beginningOfCurrentMinute()@javascript:gs.endOfCurrentMinute()'; // query to check created in last minute
var att = new GlideRecord('sys_attachment');
att.addQuery('sys_created_by', user);
att.addQuery('table_name','u_earb');
att.addEncodedQuery(str);
att.query();
if (att.next())
{
GlideSysAttachment.copy('u_earb',att.table_sys_id,'u_earb',record);
att.update();
}
