Having a few issues recording data for a third-party reporting tool. Essentially I'm trying to piece together a method with
[A few other manual inputs]
Output (to a table):
The above inputs
I'm able to get all of this information into my table except for the workflow version.
Here is my current configuration:
I guess the real question is, 'Is there any method with a 'Read' functionality to return the workflow version number from the ProcInstID?' because it looks like the list is the issue here.
Best answer by NathanBloomfiel
Thanks for your input Samuel.
I've actually been in contact with K2 themselves and been given a little bit of SQL code as we are on-prem. This returns everything we need (after a little customisation).
Attached for anyone interested.