In my CD app there is a reminder notification that is being sent out via daily scheduled job to the approver to approver pending records. Notification is working fine. However, the link in the notification mail which takes to the approver to the pending records is not working after go live. How can I fix this? What could possibly go wrong? Here is the body of the mail
and here is the email script
(function runMailScript(current, template, email, email_action, event) {
var previousBatchName = "";
var currentBatchName = "";
var count = 1;
var tableData = JSON.parse(event.parm2);
if (tableData.length > 0) {
template.print("<style>table, th, td {border:1px solid black;border-collapse:collapse;padding:10px}</style>");
template.print("<table><tbody><tr style=background-color:rgb(17,44,64);color:white><th>Batch Name</th><th>Total no. of records</th><th>Date of Request</th><th>Assigned to</th></tr>");
var i = 0;
while (i < tableData.length) {
currentBatchName = tableData[i].batch_name.toString();
if (previousBatchName != currentBatchName) {
count=getTotalRecords(currentBatchName);
var batchLink = "<a href='/x_snc_test_run_b_0_npi_approval_tracker_list.do?sysparm_query=batch_folder_name=" + tableData[i].batch_name.toString() + "'>" + tableData[i].batch_name.toString() + "</a>";
template.print("<tr style=border 1px solid black><td>" + batchLink + "</td><td>" + count + "</td><td>" + tableData[i].date_of_request + "</td><td>" + tableData[i].assigned_to.toString() + "</td></tr>");
//reciepient.push(tableData[i].assigned_to);
}
previousBatchName = currentBatchName;
i++;
}
template.print("</tbody></table>");
}
email.addAddress("cc", "revenue.products@servicenow.com");
function getTotalRecords(batchName)
{
var result=0;
var j=0;
while(j<tableData.length)
{
if(tableData[j].batch_name==batchName)
{
result++;
}
j++;
}
return result;
}
})(current, template, email, email_action, event);
