cancel
Showing results for 
Search instead for 
Did you mean: 

Sql to count number of processes using different process definition versions?

tygerc
Champ in-the-making
Champ in-the-making
Since updating the process definition means that we have to be really careful when updating Java code and Camel routes, it would help to know how many running processes are using old process definitions. E.g. when can we dump the code the new one doesn't use anymore.

We cannot use Activiti explorer in production, so has anyone already written sql to get that kind of information from the database?
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
The ProcessInstanceQuery can give you exactly that information.