This is in Laserfiche Cloud. I am unable to retrieve multiple rows from the Run Rule Workflow Activity. I have a query that returns all rows of a lookup table. In the example, I have 7 rows, which is displayed correctly when I test the query; however, when I test the rule activity in workflow, it only ever returns 1 row. Even if I iterate using a For Each Row activity, it correctly iterates 7 times but cannot find the corresponding value in each row so it returns a blank.
Question
Question
LF Cloud Workflow Run Rule Activity: Unable to return multiple rows?
Replies
Do you have a _totalRows column?
It should show 7. For the Total Results being 1, I don't have an answer.
Yep, and it shows 7.
Hi Michael,
The Test Results Dialog for the Run Rule activity only displays the top result to verify formatting in your Workflow.
Jasciel is correct, the total rows is incorrectly always showing 1 total result. I'll bring that back to the team.
Thanks Kevin. I think I ran into an issue with the For Each Row Activity. I was not able to assign the resulting values to a multi-valued token in the For Each Row using the current values. It loops the correct number of times (7), but no values get assigned to the token. Perhaps a bug or I'm not using it correctly?
I was able to accomplish this by using the For Each Row Activity and applying an index on each output value from the Run Rule activity using the iterator from the For Each Row. Nothing else was changed, but I got the expected output doing it this way. See relevant pictures.