Best approach for Birthdate interface

Here's the option we would use:
1. add a new index to EMPLOYEE (which is what we did, i don't think EMPSET97 is delivered), where key = Company, Supervisor & Employee.
2. Build a query using EMPLOYEE and the new key and the relation on PAEMPLOYEE to do a "Select where PAEMPLOYEE.BIRTHDATE month = current month.
3. Branch to send the email when the supervisor number changes, else continue spinning thru the query adding the results to a MsgBuilder node.

I am not sure how to accomplish #3 though. How in the branch am I telling it to hold the data until supervisor A switches to supervisor B?
Thanks, April

Not a problem April, although i'll put a disclamier here that this is only one way to accomplish this, SO...
In the Start node add 2 variables: one that will hold the EMPLOYEE.SUPERVISOR value, the other is a variable to let the flow know this is the first time thru the query. initialize both to spaces, Ex: firstFound=="", superNum=="".

Here's how the query loop would work:
After the EMPLOYEE table query, add a branch where one leg goes to an assign if firstFound="". Assign the supervisor number just found to the variable . You'll only do this assignment once as this is your initial seeding of the supervisor number that you will use later in the loop to determine when the supervisor number changes. Each time you go thru the query loop you'll either add birthdates to the MsgBuilder node or send the email, depending on if the supervisor has changed. Toward the end of the query loop, update superNum with the EMPLOYEE.SUPERVISOR = superNum so that always contains the latest suprvisor found.

Depending on your javascripting experience and if you want to add custom code to pflow.js, some of this could be handled by pflow.js.

I've roughed out a query loop in Designer. Email me and I can send a screen shot. There are no guts behind the nodes, but at least you could "see" what I'm thinking.

If you have the HRSUPER table hierarchy set up, you can query/loop on HRSUPER, then have an inner loop for each supervisor that looks for the supervisor's direct reports who have birthdays.