Hello @Haritej
Once the RITM is created the attachment in ritm variables is stored in sys_attachment table with table name as ZZ_YYsc_req_item and table sys_id as RITM sys_id.
To add the same attachment in RITM, create a new business rule.
Configure the Business Rule:
- Name: Give your business rule a descriptive name (e.g., "Copy Attachments to RITM").
- Table: Set this to Requested Item [sc_req_item].
- When: Set this to after.
- Insert: Check this option (so it runs after the RITM record is created
In the Script field, you can use the following code snippet:
(function executeRule(current, previous /*null when async*/) {
// Query attachments associated with the catalog item
var attachmentGR = new GlideRecord('sys_attachment');
attachmentGR.addQuery('table_name', 'ZZ_YYsc_req_item'); // Your attachment table
attachmentGR.addQuery('table_sys_id', current.sys_id); // Your catalog item sys_id
attachmentGR.query();
// Loop through the attachments and copy them to the RITM
while (attachmentGR.next()) {
var attachment = new GlideRecord('sys_attachment');
attachment.initialize();
attachment.file_name = attachmentGR.file_name;
attachment.content_type = attachmentGR.content_type;
attachment.table_name = 'sc_req_item'; // Set to RITM table
attachment.table_sys_id = current.sys_id; // Set to current RITM sys_id
attachment.insert(); // Insert the attachment into RITM
}
})(current, previous);To add the attachment in email notification, create new notification.
Set the Notification Conditions:
- Define the Table (e.g., sc_req_item for RITM).
- Set conditions for when the notification should be sent.
- Configure who will receive.
Next step is to create a new email script(sys_script_email).
In the Script field, you can use the following code snippet:
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
// Add your code here
var attachmentGR = new GlideRecord('sys_attachment');
attachmentGR.addQuery('table_name', 'sc_req_item');
attachmentGR.addQuery('table_sys_id', current.sys_id);
attachmentGR.query();
var attachments = '';
while (attachmentGR.next()) {
var attachmentLink = attachmentGR.getLink();
attachments += '<br><a href="' + attachmentLink + '">' + attachmentGR.file_name + '</a>';
}
// Add the attachment links to the email body
email.setBody('<br><strong>Attachments:</strong>' + attachments);
})(current, template, email, email_action, event)Call the script include in notification body:
Check for the attachment in email body section once is notification is sent.
"If you found my answer helpful, please give it a like and mark it as the accepted solution. It helps others find the solution more easily and supports the community!"
Thank You
Juhi Poddar
