Resend email

[shaik23]

Hi all,

i am having requirement to resend emails for approvals using ui action 

i have a script i need suggestion 

resendThisApproval();

action.setRedirectURL(current.sysapproval)

function resendThisApproval() {

   var e = new GlideRecord("sys_email");

   e.addQuery("type", "sent");

   e.addQuery("target_table", current.getTableName());

   e.addQuery("instance", current.sys_id);

   e.orderByDesc("sys_created_on");

   e.setLimit(1);

   e.query();

   if (e.next()) {

      e.mailbox = "outbox";

      e.type = "send-ready";

      if (e.update()) {

         gs.addInfoMessage("Resent: " + e.subject);

      } else {

         gs.addErrorMessage("Could not resend: " + e.subject);

      }

   } else {

      gs.addErrorMessage("Approval email not found for " + current.approver.name + " / " + current.sysapproval.number);

   }

}

[shaik23]

@Sandeep Rajput  i am getting this error when the script executes 

[Sandeep Rajput]

@shaik23 Looks like the glide query you are using to fetch the record is not returning any result. Could you please post the updated script here?

[shaik23]

@Sandeep Rajput  That is the script i have

[Sandeep Rajput]

@shaik23 

 var e = new GlideRecord("sys_email");
   e.addQuery("type", "sent");
   e.addQuery("target_table", current.getTableName());
   e.addQuery("instance", current.sys_id);
   e.orderByDesc("sys_created_on");
   e.setLimit(1);
   e.query();

Looks like this query is not returning any result. I recommend running this script as a background script by replacing current.getTableName() with table name and current.sys_id with the sys_id in consideration and check if the query returns anything.

[shaik23]

the target table is approval