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".
Best answer by mpgibbs
View original
+8
Hello,
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;
Regards,
Matt
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?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
