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

Question

Question

LF Cloud Workflow Run Rule Activity: Unable to return multiple rows?

asked on February 21, 2024

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.

lf-3.png
lf-4.png
lf-3.png (89.31 KB)
lf-4.png (33.3 KB)
0 0

Replies

replied on February 21, 2024

Do you have a _totalRows column?

It should show 7. For the Total Results being 1, I don't have an answer. 

1 0
replied on February 21, 2024

Yep, and it shows 7.

lf-5.png
lf-5.png (30.79 KB)
0 0
replied on February 21, 2024

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.

1 0
replied on February 22, 2024

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.

wf-1.png
wf-2.png
wf-3.png
wf-1.png (16.03 KB)
wf-2.png (16.89 KB)
wf-3.png (18.73 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.