Hi I have a scheduled job that execute the script below, but I am using GlideAggregate to groupby the approver. But how I can accomplish this using flow designer so I can move scheduled job into Flow designer.
function execute() {
/* query approval table with GlideAggregate*/
var approval = new GlideAggregate('sysapproval_approver');
/* select only requested records */
approval.addEncodedQuery('state=requested^due_dateRELATIVELT@dayofweek@ago@6');
/* group by approver in order to get unique values (one distinct user at a time) */
approval.groupBy("approver");
approval.query();
while (approval.next()) {
/* Create a unique Scheduled Report */
createScheduleReport(approval.approver);
}
}
