IPA Node Question

unknown

I wanted to see if anyone had any recommendations for which node might work for this process:

 

1. Start
2. SQL Query generates a query of information.
3. MsgBuilder – to build a list of the queried information
4. The goal here is to send a list of information to the appropriate managers email showing only those employees that report to that manager?? Which node would I use to break out the MsgBuilder information so that it will loop around by email address.
5. Email communication
6. End

Thank you,

Craig

unknown

I missed an import "NOT" in my response.

I'm assuming your SQL query will include the manager's email address.  So Sort your query on the Manager's email address followed by what else you might want to sort by.

with in the SQL Query loop you would have a branch to see if the email address in this query's row of data matches what is on the prior row. 

If it's different and prior manager email address is NOT blank then you send what you have in the Msg builder to the prior manager email address. And blank out the message builder. 

after that branch you would put the current query row data into the msg builder and set the prior manager email address to the value in the sql query.

after the SQL query - you will need to send a final email to the last manager email address.