How to include only newly added attachment on mail and remove other attachments?

sruthig
Tera Expert

Hi All,

We have configured like when any additional comments added to the case it will sent mails to users in watch list. If any work notes added to the case it will sent mails to users in the work notes list. So in the notification selected "include attachment option".

All the attachment is attaching every time when any mail sent for additional comments or work notes added. How to include only latest updated attachments in the mail?

 

Please suggest

Regards,

Sruthi

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@sruthig 

you cannot include single attachment using the Include Attachment checkbox

you will have to uncheck that and include the attachment link in the email

Use email script to get the latest attachment link and use that email script in the notification

Email Script:

Name - show_specific_attachment

(function runMailScript(current, template, email, email_action, event) {

    // Add your code here
   
    var gr = new GlideRecord('sys_attachment');
    gr.orderByDesc('sys_creatd_on'); //sort with created descending
    gr.addQuery('table_sys_id', current.sys_id);
    gr.setLimit(1); // pick only 1 attachment record
    gr.query();
    if (gr.hasNext()) {
        template.print("Attachment: <br />");
        while (gr.next()) {
            var url = gr.getTableName() + ".do?sys_id=" + gr.getValue('sys_id');
            var attachLink = '<a href="' + url +  '">' + gr.file_name + '</a>';
            template.print(attachLink +  "<br />");
        }
        template.print("<hr/>");
    }

})(current, template, email, email_action, event);

In notification include the email script as below

${mail_script:show_specific_attachment}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

15 REPLIES 15

@sruthig 

Hope you are doing good.

Glad to know that my response helped you.

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@sruthig 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Ankur Bawiskar , Is there a way to add physical attachment itself instead of links. If we use "Include Attachments" it will be sending all attachments but I want send the last attachment as per the above logic.  

Hi @Ankur Bawiskar 

 

Will Including mail script in notifications will work for external users who don't have access to servicenow instance?

Willem
Giga Sage
Giga Sage

@sruthig did this help you? If so, can you mark answer as helpful and correct? That way others can find the answer as well.