Good morning community,
I am setting up a simple scheduled report, trying to use a script I found from another post as the conditional script to generate the recipients from running the report query. However, from what I can see, the conditional script is not running. I get no log statements, no nothing unless I manually add a recipient the normal way, and then it only sends to that recipient and still no log statements or.
Does anyone see what I am doing wrong? This is a stale approval report that I want to send to all the people with pending approvals.
var scheduleReport = new GlideRecord('sysauto_report');
scheduleReport.get(current.sys_id); //Sys ID of your schedule Report
var tablename = scheduleReport.report.table;
var query = scheduleReport.report.filter;
var users = '';
gs.log('JAL ' +tablename + ' ' +query + ' ');
//Execute the report as a GlideRecord with the set table and condition
var gr = new GlideRecord(tablename);
gr.addEncodedQuery(query);
gr.query();
while (gr.next()) {
users += ',' + gr.approver;
gs.log('JAL ' +gr.approver);
current.user_list = users;
current.update();
// Need to set this true for condition script to run
answer = true;}
