Is there anywhere in the K2 database or reports that capture when a particular task was allocated to a user? I've found good levels of detail on when a task is redirectred, completed, and released but not when it is set to "Open".
Solved! Go to Solution.
You can run something such as follows to see who opened the task and when etc...
SELECT WLS.ProcInstID, A.ActionerName, WLS.AllocDate
FROM Server.WorklistSlot WLS
JOIN Server.Actioner A
ON WLS.ActionerID = A.ID
WHERE WLS.Status = 1;
Wow, thank you! I was focused on the ServerLog schema as I was under the impression that data in the Server schema only pertains to Active process instances. That doesn't seem to be the case with this particular table, or am I mistaken?
Thanks Khanh, that's what I ended up doing. Unfortunately, I've found that once the process instance ends, the data in the Server.WorklistSlot table is removed. I was hoping to have it for historical reporting even on tasks that are done. Does this data go anywhere in the [ServerLog] schema like much of the other Server tables?