tbyrne777
Cloud Wanderer

Capture When a Task is Allocated?

Jump to solution

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".

0 Kudos
Reply
3 Replies
mpgibbs
Nintex Newbie

Re: Capture When a Task is Allocated?

Jump to solution

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

View solution in original post

Reply
tbyrne777
Cloud Wanderer

Re: Capture When a Task is Allocated?

Jump to solution

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?

0 Kudos
Reply
tbyrne777
Cloud Wanderer

Re: Capture When a Task is Allocated?

Jump to solution

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?

0 Kudos
Reply