Send Email to the task assignee using a task report

Question

Hi, 
 I have got the below scenario, 
 I'm having a task report (having task assignee, taskid and task name etc,). 
 Note: Each assignee might have more than one task. 
 
 I need to get the task details of each assignee and send an email to that assignee by keeping his/her task's in the email body (email body should contain each task Link to complete the task). 
 
 example: 
 if an user 'A' having three tasks, then we need to send an single email with three tasks links in the email body. 
 
 Please suggest me a best approach for this.

Carlos Santander · Answer

At a high level: 
 
 Create a process model configured to run on a schedule (however frequently you want those emails to go out to the users) 
 Add an Execute Process Report node to run the task report and get its data 
 Iterate over the results to aggregate tasks by assignee (one possibility is to write a rule that uses the reduce function) 
 Use MNI to send an email to each assignee

Carlos Santander · Answer

You define a rule that you'll pass to reduce like so: reduce(rule!APP_myRule, {}, pv!taskReportResults). In APP_myRule you would check if the list item (a row from your task report) is for an assignee that you already processed (in which case you would add it to that assignee's list) or if it's a new one (in which case you create a new list).