Question

Query Forms Database Using Entry ID

Forms Workflow

Updated July 25, 2022

asked on July 25, 2022

Greetings community! I'm wondering if I might be able to save myself some time if someone else has already created something similar to what I am needing.

We have entries that come into the repository and then Workflow kicks off a Forms instance for those to go down an approval path. I am needing to create a workflow that returns all entries in the repository within a specific folder (that's easy enough) and then using the Entry ID (it is a variable in the Forms process) find if any active Forms instances are running for it within the specific Forms Process.

Has anyone created a workflow that does that or something similar? I'm sure I can create it, just trying to save time.

0 0

Replies

replied on July 25, 2022

Even better would be a SQL query that does a join with the Forms and Repository databases and just gives the results.

0 0

replied on July 25, 2022

Out of curiosity, what do you do with the results?

0 0

replied on July 25, 2022

We have a rather complex and large approval process that occasionally has its hiccups. We would use the results to find out which documents do not have active Forms instances running for them so we can look into why and see if we need to kick one off.

0 0

You are not allowed to follow up in this post.

Question

Question

Query Forms Database Using Entry ID

Replies

Sign in to reply to this post.