topic Re: How ist the duration calculated in History tables? in Alfresco Archive

How ist the duration calculated in History tables?

nikki — Tue, 15 Feb 2011 12:39:54 GMT

Hello together,I try to analyse the history data of process instances. How is the duration calculated in history tables? If I calculate a duration by deducting End_Time and Start_Time I come to other results, than in history service. So do I have a format problem?Thanks for your help!greets Nikki

Re: How ist the duration calculated in History tables?

frederikherema1 — Tue, 15 Feb 2011 12:44:50 GMT

Duration (in millis) is calculated based in start and end-time (HistoricScopeInstanceEntity):


 public void markEnded(String deleteReason) {
    this.deleteReason = deleteReason;
    this.endTime = ClockUtil.getCurrentTime();
    this.durationInMillis = endTime.getTime() - startTime.getTime();
  }

Are you using MySQL? The timestamp type is only accurate to the second, milliseconds can differ from the actual value used for calculation.

Re: How ist the duration calculated in History tables?

nikki — Tue, 15 Feb 2011 13:25:13 GMT

Thanks for your help!