Attempting to teach myself "Set Business Process Variables" and have created a test workflow and form. To keep it simple, the test is working with just 1 token. I have a custom query that is returning 15 rows for the "date_Effective" however I have not been able to return all 15 rows as tokens. I have included my screenshots, I'm sure this is easy to fix, I'm just not sure how?
In the first image I have the properties "For Each Row", in the second I have the properties for the "assign token values" and the third the properties for "Set Business Process Variables" The problem appears to be in the configure token, it's only grabbing 1 of the 15 rows. The activity in my mind, I have outlined to take the custom query, and the token date_effective and create a token for each row. Does not appear to be working like that. I have also used create token with multiple values and that does not seem to work.