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
Capture When a Task is Allocated?
Best answer by mpgibbs
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
+8Hello,
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
Translate
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?
Translate
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?
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.