Question

"Average Duration" for Business Process - how to reset statistics?

Workflow

Updated September 28, 2017

asked on April 22, 2015

Hello everyone!

Is there somewhere we can reset the statistics for a business process?

For example - if you look at the BP pane on a document in a BP, you will see an "Average Duration" of that BP.

I can't find where I can reset that number. (Testing is coming to an end, and now we need it to go live with fresh new stats.)

Thanks in advance!

1 0

Answer

SELECTED ANSWER

replied on April 27, 2015

There is no easy way to do it other than going directly into SQL. The instance history is kept in the bizproc_entity, bizproc_entity_entry and journal_entry tables. Depending on whether you want to wipe out all history or just some, you may have to refine your queries by the business process' ID from the bizproc table.

As usual, making sure you have a proper backup is step #0 before you touch the SQL database.

3 0

replied on April 27, 2015

Ah, OK Miruna. Thanks.

0 0

Replies

replied on April 27, 2015

Anybody?

I keep digging, but so far, nothing.

1 0

replied on September 28, 2017

Hi,

I was just looking to confirm if this is still the recommended way to reset the statistics on Business Processes. I've contacted support but unfortunately they have been unwilling to provide any assistance at all.

Can someone from Laserfiche confirm that to reset the stats we would simply delete all rows from the bizproc_entity, bizproc_entity_entry and journal_entry tables?

0 0

You are not allowed to follow up in this post.

Question

Question

"Average Duration" for Business Process - how to reset statistics?

Answer

Replies

Sign in to reply to this post.