Workflow - Get Business Process Info

replied on June 6, 2019 • Show version history

Good catch!

An idea might be to directly query the Workflow database. There are some in-box views that might have what you need.

0 0

View 2 previous replies

replied on June 7, 2019

I don't know if this would contain any repository information. The entries I want to review are stored in the repository, but the workflow database holds workflow definitions and recent activity only I believe.

0 0

replied on June 7, 2019

It'll likely be a multi-step process. You can start at the bp_instances table, and hop over to bp_data by joining on bpi_id. From there you'll get a number of rows, each of which has a different bpd_type. One of those will be $ENTRY, and the bpd_int_data field of that row will be the entry id.

You can then do a cross database query to get to the entry in the repository.

0 0

replied on June 7, 2019

Got it, I guess my concern was that workflow does not keep a history of business processes run on entries for very long. A few months with the default settings.

0 0

replied on June 7, 2019

Good point. It would be nice to split that out and have the option of making certain business process logs permanent.

0 0

replied on June 7, 2019

You want to look at the BusinessProcessEntity class in the SDK. Anything you tracked as part of your business process (and appears in the Business Processes pane in the desktop/web client) is saved to the repository and not subject to Workflow's cleanup rules.

1 0

Question

Question

Workflow - Get Business Process Info

Replies

Sign in to reply to this post.