Answers to: getBusinessRuntime() from the last running case

Comment by Reguel Wermelinger on Gabriele's answer

Reguel Wermelinger — Tue, 28 Jun 2016 14:00:58 -0400

I agree, the query from reto only works with 6.2 which will be released this week.

Answer by Gabriele

Gabriele — Tue, 28 Jun 2016 11:00:48 -0400

Hi Reto, First of all thank's for your help. You probably don't use the 6.1 Designer Version. Your query doesn't work because of the executor(). It tooks me a lot of time to find a way to get the runtime of the last running case. See below.

import ch.ivyteam.ivy.workflow.CaseState;
import ch.ivyteam.ivy.workflow.query.CaseQuery;
import ch.ivyteam.ivy.workflow.ICase;

CaseQuery caze = CaseQuery.create().where().name().isEqual("Laufzeit").and().state().isEqual(CaseState.DONE);
Number count = ivy.wf.getCaseQueryExecutor().getCount(caze);
ivy.log.info("count "+count); //Zähler prüfen
if (count != 0){
    Recordset erg = ivy.wf.getCaseQueryExecutor().getRecordset(caze.groupBy().businessRuntime());
    ivy.log.info("letzteRuntime "+erg.getField(count-1,0));
}

Answer by Reto Weiss

Reto Weiss — Fri, 24 Jun 2016 14:45:18 -0400

Use the classes TaskQuery or CaseQuery to query for tasks and cases that have already been done. And then call the method getBusinessRuntime() on the returning results.

Example:

import ch.ivyteam.ivy.workflow.CaseState;
import ch.ivyteam.ivy.workflow.query.CaseQuery;
import ch.ivyteam.ivy.workflow.ICase;

ICase caze = CaseQuery.create().where().name().isEqual("MyCase").and().state().isEqual(CaseState.DONE).executor().firstResult() as ICase;
caze.getBusinessRuntime();