Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Scheduled Report to get emails of the approvers

Shree Nag
Tera Expert

Hello,

I have created with a report which has requested items that is pending approvals with approver info.

I have scheduled that report to be sent through email to all the approvers generated in the report. The script on the scheduled report is from this link.

I changed all "assigned_to" to "Approver". 

When I execute the scheduled report, no emails are generated. Please guide me what could be wrong

Attached the report and scheduled report script.

 

Script is schedule report:

 

answer = lookupUsersAndUpdateReport();
function lookupUsersAndUpdateReport(){
    // look up "assigned_to" people -- assumes "table" is task-based
    var senderArray = [];
    var PrevSender = '';

    var taskQueryGR = new GlideRecord(current.report.table);
    taskQueryGR.addEncodedQuery(current.report.filter);
    taskQueryGR.addEncodedQuery('assigned_toISNOTEMPTY');
    taskQueryGR.orderBy('assigned_to');
    taskQueryGR.query();
    while (taskQueryGR.next()){
        if (PrevSender != taskQueryGR.assigned_to + ''){ //filters out duplicate assignees
            senderArray.push(taskQueryGR.assigned_to + '');
            PrevSender = taskQueryGR.assigned_to + '';
        }
    }

    current.user_list = senderArray.join(',');
    current.setWorkflow(false);
    current.update();
    current.setWorkflow(true);

    // only return true if there were records listed in the result set
    if (senderArray.length > 0){
        return true;
    }
    return false;
}
0 REPLIES 0