Question

Fillable PDF only creating 2 pdfs but should be 4 pdfs

Workflow

Updated May 27, 2020

asked on May 27, 2020

I am trying to create filled pds using data in our sql db. I have the following workflow. The custom sql query returns 4 rows, but only 2 of the 4 pdf files are getting saved in the repository. Any ideas as to what I am doing wrong?

0 0

Replies

replied on May 27, 2020

Hi Margo,

Have you tested that the SQL query returns 4 rows using the 'Test...' button in Workflow? It could have a different result that when/if you ran it directly in SQL.

Additionally, do you have it set to return all rows or only the first two? (I believe my screenshot is the default.)

1 0

replied on May 27, 2020

Thanks so much for your quick reply. Yes, I did hit the test button and it returned 4 rows. That said, however, the rows to return was set the the default of 2 rows. I changed it to all rows, and now it works!! Thanks, again!

0 0

replied on May 27, 2020

Margo,

A couple of thoughts;

You can add a Track Tokens activity to your workflow to see the actual count of records returned by the SQL query.
The Move Entry and Rename Entry activities seem to be redundant. You should be able to set the final folder destination and final document name in the Create Document activity.

0 0

You are not allowed to follow up in this post.

Question

Question

Fillable PDF only creating 2 pdfs but should be 4 pdfs

Replies

Sign in to reply to this post.