You are viewing limited content. For full access, please sign in.

Question

Question

For Each Row

asked on February 19, 2020

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.  

 

Capture1.JPG
Capture2.JPG
Capture3.JPG
Capture1.JPG (28.3 KB)
Capture2.JPG (24.16 KB)
Capture3.JPG (69.46 KB)
0 0

Answer

SELECTED ANSWER
replied on February 19, 2020

You want to create the token before you go into For Each Row and make it multi-value. In For Each Row, modify it to append the current value.

The way you currently have it set up, you're re-creating the token at each pass and giving it one value.

4 0
replied on February 19, 2020

Thanks Miruna, that was my problem.  Working as I had hoped now.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.