Copy attachments from an RITM request to the sys_approval_approver table

[Peter Williams]

good day, 

i have a business case here.

When a user submit a catalog item, it will create an RITM request with an attachment but if the user forgets to attach and item, i would like to have the ability for the user to attach the document onto the open RITM request and then have that attachment to appear for the Approver in the email.

ex.

the item highlighted is a newly attached Doc

i want that doc to now appear for the approver here:

i tried business rules on the sc_req_item table and sys_attachment but nothing seem to work and i am stuck here

PLEASE HELP...

[Peter Williams]

ok so it added the items to the approver table once i updated the record for the approver however now its adding the existing doc. along with the new doc. i am getting duplicates

[Ayushi12]

Hi @Peter Williams  
As Business rule condition is Insert and Update both hence when you update the approval record, script check for all attachments and update attachments in approval record which result in duplicate. If all attachments are added before the approval record creation you can update the business rule only on Insert condition so it will update attachment only once.

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks!

[Peter Williams]

are you saying just use the Update and uncheck the insert

[Peter Williams]

so i tried both options, Insert only - Doesnt attach the attachment to the Approver record.
Update only - attach all records including the existing attachment that was already on the request in the first place so its causing duplicates on the approver record

[Ravi Peddineni]

@Peter Williams 

Will the solution proposed at  TNT: Improving the Attachments List View solve the bigger part of you requirement?