Answers to: Is it possible to analyze process runtime in Axon.ivy Designer?

Comment by Reto Weiss on Gabriele's answer

Reto Weiss — Thu, 16 Jun 2016 16:20:24 -0400

The executor() method was introduced in version 6.1. That's why my query does not work. Your solution does the same and works also with older versions.

Answer by Gabriele

Gabriele — Thu, 16 Jun 2016 14:06:29 -0400

Hi Reto, Thank's for your help, unfortunately the statement you have posted doesn't work. But I was successful with try and error and found a query that provides the average time for one instance of my process: ivy.log.info("runtime" + ivy.wf.getCaseQueryExecutor().getRecordset(CaseQuery.create().aggregate().avgBusinessRuntime())); or the time of all instances in a sum ivy.log.info("runtimeSum" + ivy.wf.getCaseQueryExecutor().getRecordset(CaseQuery.create().aggregate().sumBusinessRuntime()));

Regards Gabriele

Answer by Reto Weiss

Reto Weiss — Tue, 14 Jun 2016 17:37:31 -0400

Not sure if I understand you question correct. With the following script you get the avarage business runtime of all process instances that were executed:

import ch.ivyteam.ivy.workflow.query.CaseQuery;
Object result = CaseQuery.create().aggregate().avgBusinessRuntime().executor().firstValue();

Have a look at the CaseQuery and aggregate function there are a lot of additional functions available. There is also a TaskQuery to aggregate runtime data of tasks.