This is for our Evidence Sharing system:

We have a workflow that searches all the files and sub folders within a specific folder (started by a user as a business process.) We call these Case Folders.

It collects and calculates metadata some single vars and some multi-value vars and passes those records to a form.

The form then passes all these records back to another workflow where we merge the data into a Word document called an evidence log. Reason this is merged to a Word document is that the users have to be able to edit the evidence log to include physical evidence that is not stored in Laserfiche, I suppose we could allow them to create an entry for this evidence as well but that will still not solve our issue

This process has worked flawlessly for years. However, the digital age now means that we also include phone dumps and tons of body cam and dash cam videos as well as all sorts of other digital data.

In other words, some cases often have thousands of evidence documents within the case folders in Laserfiche. (We know Word is limited to 32767 rows, so we know we are also limited by this number.)

Due to the sheer number of records, the process times out, (so far I have seen it timeout with 5000 and over files/folders, however it may even be smaller than that).  There does not seem to be a timeout we can set to allow it to pass to forms and no timeout to be set to pass it back from forms to workflow.

Since merging with a Word document apparently can only be done with data that comes from a forms business process, is there any way to change the timeout when the form passes info back to the workflow server so that we can extend the time it has to hopefully pass all the thousands of records back to Workflow?

Alternatively how can I access variables to merge into a Word document that do not come from a business process? I have thought about passing info to SQL but then forms does not have access to that SQL table immediately either. So that was a dead end.