Hi everyone,

In one of my own developed reports using the standard K2 SmartObject Activity_Instance_Destination, I encounter some strange values in 'Duration'. See (simplified)query and result below:

SELECT z.Destination,
             z.ProcessName,
             z.ActivityName,
             z.StartDate,
             z.FinishDate,
             z.Duration
FROM  Activity_Instance_Destination z
WHERE  z.ProcessName = @N

Destination   ProcessName   ActivityName   StartDate                  FinishDate              Duration

P16639          KV                         Behandelen   30-6-2010 7:42:03 1-7-2010 9:46:07   93844

p16639          KV                         Wachten          1-7-2010 9:45:55   1-7-2010 9:46:15   2503288

P16639          KV                         Annuleren        5-7-2010 9:47:31   5-7-2010 9:47:55   2157592

In some cases Duration (which is in secs) does not match with StartDate and FinishDate. Is this a bug?

Yours,

Ruud