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

Question

Question

Workflow Database View

Workflow
Updated August 6, 2015
asked on August 5, 2015

I am wanting to have my workflow look for the last time it finished successfully and use that date as a value in the current instance.  While I've not found any tokens in Workflow that grant you access to the Workflow's history, I did notice their is a view in the database called "dbo.Workflows" that has information on each instance of each workflow.  Before I write my workflow to utilize this I wanted to see if:

  1. Anyone has found a better way to get Workflow instance information via a Workflow?  Possibly through a web call or some other query?
  2. Anyone has used this view to consistently query for Workflow statuses?
  3. This view will be around for the long-haul or is it something I should not count on in future versions (i.e. LF 10)?
0 0

Answer

SELECTED ANSWER
replied on August 5, 2015

Can you explain what you're trying to do with this information? Due to how you can have multiple instances running at the same time, we didn't see the usefulness of providing this information.

The view is provided specifically for the purpose of designing reports directly on the database and still allow Laserfiche to change the underlying table structure as needed. It is unlikely to disappear in future versions. It will definitely be there in v10.

1 0

Replies

replied on August 5, 2015

I have a workflow that runs on a scheduled start rule every hour and runs in single instance mode.  I want to have it look for anything that has changed in a Finance database since the last successful time this workflow ran.  While I could hardcode it just to look for anything that changed in the last hour, that would not account for instances where the workflow might have failed or the servers are down.  Instead, I want this workflow to find the last time it finished successfully and use that start time as the comparison time in the other database I am querying. I'm trying to write an efficient workflow that can account for the various outages that can affect a system.

0 0
replied on August 5, 2015

Thank you, that helps.

0 0
replied on August 6, 2015

Thanks for advising it will be available in LF 10.  I will continue writing my Workflow to query this view unless anyone has a better suggestion or reason why this might not be the best idea.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...